Send data with JSON API - looking for an easy trick | XM Community
Skip to main content

I need to send back embedded data using https://api.qualtrics.com/2ced5de7dc638-start-an-update-embedded-data-job#response-body  I have all of it on excel. Is there an easy way to transform the excel to the formate requested here without being a JSON knowledgable or other coding options?

@Nam Nguyen maybe you have an idea? I tried an online tool that transformed the excel to JSON, but the issue is that in between there’s a need to have this line for exmple  "embeddedData": {, and extra } at the end… 

 

Is there something I’m missing that works well?

 

@deveer2024 

  1. If you have chatGPT, upload the file, give them the format you want to create, it will automatically do the job for you
  2. Or else, you have to know some excel, use concatenate to put the field name and value in the right order with the symbols inbetween (all the { “ ” : ” ” } ). Now if you put the new one under collumn named embeddedData then it’s all good with the online converter. Remember the Object begin with "updates": t…….
  3. There’s also an alternative way without JSON preparing, which is this API https://api.qualtrics.com/daed82306b1ea-update-response but this will require your code to walk through the excel file one by one.

Thanks @Nam Nguyen ! I’m going to get this investigate some more… I tryed chatGPT but it didn’t prepare for me the entire 300 or so raws… Maybe I should give this another shot


Thanks @Nam Nguyen ! I’m going to get this investigate some more… I tryed chatGPT but it didn’t prepare for me the entire 300 or so raws… Maybe I should give this another shot

@deveer2024 State you order clearly. E.g: I want this collumn named…. to be in this part named…. of the JSON. The AI is smart, but they need clear instruction.


@deveer2024,

You can use this web site to convert a CSV to JSON:

https://www.convertcsv.com/csv-to-json.htm


@deveer2024,

You can use this web site to convert a CSV to JSON:

https://www.convertcsv.com/csv-to-json.htm

@TomG Do you know any online converter that has a way to do nested JSON? I think the problem here is easiest way to nesting JSON from Excel.


@deveer2024,

You can use this web site to convert a CSV to JSON:

https://www.convertcsv.com/csv-to-json.htm

@TomG Do you know any online converter that has a way to do nested JSON? I think the problem here is easiest way to nesting JSON from Excel.

The convertcsv site can use templates that could support nesting.


Leave a Reply