Dynamic list attribute to JSON Response format

Do you need to create a JSON document (middle image) based on the list attribute "_treediseaseList" (left image)?

If so, where the IDs (AnswerID, InspectionID, QuestionID) corresponding to each AnswerValue (disease name) are come from?

Hello @Takashi Iijima​ ,

I'm populating a Cityworks Inspection Template based on these values, In the template, each question and answer option have ID's

If it was select one question I use an attribute creator and JSON Templater to make up the JSON for the request. For a select multiple there is no way to know ahead how many of these list items will be selected. The Inspection ID comes from the HTTPCaller response body which I extract using a JSON Extractor.

I think the first screenshot in your question is the source table which you need to convert to a JSON document, and I guess that the source table contains some attributes storing the IDs (question ID etc.), similar to the attribute called "treedisease" storing comma-separated tree disease names.

If so, could please share the source table?

Hello @Takashi Iijima​ 

please find the excel containing the QuestionID and AnswerID,attached here

Thankyou

This is the correct table

The attached workspace demonstrates how you can translate the Excel table to a JSON array.