I have created a flow with multiple exports, and at the end, I want to import data into Salesforce.
From the payload below, I need to insert all WOD records into Salesforce.
However, when mapping the output, the correct values do not appear. Please check the screenshot.
I set ‘One to Many’ to Yes and used the path “values”, but when I run the flow:
• No records are created.
• No errors are displayed.
Please help me troubleshoot this issue.
{
"_PARENT": {},
"JOB_NUMBER": "999999",
"GLOBAL_ID": "{TEST-GLOBAL-ID-123}",
"USER_NAME": "TEST_USER",
"CHANGE_TYPE": "Sample Edit",
"CHANGE_DATE_TIME": "2025-01-01T12:00:00",
"CHANGE_DATE_TIME_UTC": "2025-01-01T17:00:00",
"DETAIL_GLOBAL_ID": "{TEST-DETAIL-ID-456}",
"NOTES@xdata.proxy": "WORK_ORDER_HIST('999999'%2C'%7BTEST-GLOBAL-ID-123%7D')/NOTES",
"WO": [
{
"value": [
{
"JOB_NUMBER": "999999",
"NOTES@xdata.proxy": "WORK_ORDER('999999')/NOTES"
}
]
}
],
"user3": "TEST FIELD",
"WOD": [
{
"JOB_NUMBER": "999999",
"GAGE_SN": "ABC"
},
{
"JOB_NUMBER": "999999",
"GAGE_SN": "XYZ"
}
]
}