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

Send data with JSON API - looking for an easy trick

  • October 29, 2024
  • 6 replies
  • 83 views
D
Level 2 ●●
Forum|alt.badge.img+3

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?

 

Best answer by Nam Nguyen

@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": […….
  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.

6 replies

Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • Nam Nguyen
  • QPN Level 8 ●●●●●●●●
  • 1096 replies
  • Answer
  • October 29, 2024

@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": […….
  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.
Nam Nguyen - XM Technology Consultant | DXCON Vietnam
D
Level 2 ●●
Forum|alt.badge.img+3
  • deveer2024
  • Author
  • Level 2 ●●
  • 29 replies
  • October 29, 2024

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

Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • Nam Nguyen
  • QPN Level 8 ●●●●●●●●
  • 1096 replies
  • October 29, 2024

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.

Nam Nguyen - XM Technology Consultant | DXCON Vietnam
TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • TomG
  • Level 8 ●●●●●●●●
  • 6083 replies
  • October 29, 2024

@deveer2024,

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

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

Nam Nguyen
QPN Level 8 ●●●●●●●●
Forum|alt.badge.img+29
  • Nam Nguyen
  • QPN Level 8 ●●●●●●●●
  • 1096 replies
  • October 30, 2024

@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.

Nam Nguyen - XM Technology Consultant | DXCON Vietnam
TomG
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • TomG
  • Level 8 ●●●●●●●●
  • 6083 replies
  • October 30, 2024

@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.


Terms & ConditionsAccessibility statement