For the data received from Microsoft Power Automate, such as the following example: {"Q1":"1","Q2":"[\"Option 1\",\"Option 3\",\"Another Information\"]","EntityName":"UsrInfo"}, how should I record the information so that the values in Q2 are registered in separate columns?
Example:
Q1 – 1
Q2 – Option 1
Q2 – Option 3
Q2 – Other Information
Like
I don't think the OOTB webhooks will handle that structure. You'll probably have to have it go to a text field, which will store the array as a text string, then use a process on record added to parse it to put in the correct places.
Ryan
Thank you. Based on my research, this seems to be the most suitable solution. Do you have any example of a process that performs this transformation?
Hello!
OOTB webhooks will not handle such a structure.
You can use Business Processes with Custom Script Tasks. You would need:
- -Parse the JSON data using a Script Task.
-Loop through the Q2 values and save them using a Data ScriptTask.
-Trigger the Process
-Integrate the process with the incoming data from Microsoft Power -Automate via:
-Webhooks: Call a Creatio web service with the JSON payload.
-Integration Process: Use the Creatio API to receive the data directly.
Kyrylo Atamanenko,
Hello!
Do you have any example of a script to convert the data ["Option 1", "Option 3", "Another Information"] into an object and insert it into the database?
Thank you.