Web Service: Saving JSON KEY as Embedded Data

It looks like your web service is returning a flat json object when it should have levels. It should return this:
{
Person: {
1: {
name: "Susan",
color: "Purple"
},
2: {
name: "Bob",
color: "Purple",
}
}
}
Then the embedded data fields returned to Qualtrics would be:
Person.1.name
Person.1.color
Person.2.name
Person.2.color

Hmm thank you for your reply! I agree and will ask them if they can change it. I really, really appreciate the example of what the embedded data will be when it's fixed.

Hello,
For future reference (or if anyone wants to clean up code), I can't get the web service owner to give me a leveled structure. What I have done as a workaround is put JavaScript directly on a question in the survey (right after I get the query data). I don't know if this is efficient, as I smashed it together from various website examples, but it works.

Qualtrics.SurveyEngine.addOnload(function()
{
   /*Place your JavaScript here to run when the page loads*/
    fetch("APIurl?query1=value"),
   {
   method: 'get',
   headers: new Headers({
       'Authorization': 'Basic xxxxx'
   })
   })
 // RETURN SERVER RESPONSE AS TEXT
 .then((result) => {
   console.log(result);
   if (result.status != 200) { throw new Error("Bad Server Response"); }
   return result.text();
 })
 // SAVE KEY VALUE PAIRS AS EMBEDDED DATA
 .then((response) => {
   const names_and_colors = JSON.parse(response);
   var i=1;
   for (const [key, value] of Object.entries(names_and_colors)) {
   Qualtrics.SurveyEngine.setEmbeddedData("name"+i.toString(), key);
   Qualtrics.SurveyEngine.setEmbeddedData("color"+i.toString(), value);
++i;
}
});
});