Webservice task not working with error in Body URL (400)

Same error with both options

 

 

Oh, responseID should be in the URL not header, you header should have content-type and API Token

You are a saviour. Thanks a ton. It works fine. Now my actual requirement is to have a file which will have ResponseIDs and the field that I want to update. How can i pass all responseIDs in URL ?

Glad you did it. However, the API that you need to read info in a excel file and call API automatically to update response should be executed in your computer, QUaltrics workflow can’t read the file as i know. I suggest python code language.

Anyway, you learned how this API work. A huge step

Theoretically yes, this will do your update in a batch. I’m using it right now in one of my survey.

But I don’t expect you to write a huge JSONObject mannually and this API is more complex to run with lots of condition.

I cannot use any utility as our org has strict data privacy regulations. I am trying out a way to have a simple formula in excel which would concatenate the data in the json format. If that works then I shall write a macro to use the data of the cell and create a txt file and save it with .json extension. I shall let you know how it goes.

Hi,

Try using postman to run the API. We do have an option to run the API automatically for all responses using postman collection. Create the API call “api.qualtrics.com/daed82306b1ea-update-response” and wherever the value should be dynamically passed, write the field name within curly brace like {{ResponseId}}. This should exactly match the column name in csv file. Then save the collection and run the collection by selecting the csv file with all data. This should ease the process of updating all records automatically.

Steps to run the postman collection: Working with data files: ramen (getpostman.com)

@Neha Tank , Enter the client id, client secret and access token url in postman and click on get new access token. Then a pop up window will open, click on process and then another pop-up window will open, click on use token. This will automatically add the token to your api call. Then just run the API.

Also every time I run the API in future, do I need to generate bearer token every time ? In API token I think it runs until the user is active.

Worked like gem :)

Hopefully the last question…. I am planning to run this API through webservice task in workflow. Do I need to generate Bearer token everytime I want to run the task ?

Do I need to generate Bearer token everytime I want to run the task ?