Hello Community members,
I have a question regarding multi-level JSON payloads (code below). This multi level payload used to work perfectly, but after the latest Alteryx update to 2024.2 the delimiter for "value" ( ' ) is no longer working and causing the API connection to fail (Error description - Parameter string value must be valid JSON) Do you happen to know what the new delimiter we can use would be to get these APIs working again?
{
"questions": [
{
"name": "Input",
"value": '
{"event":{"id":"ff99d0e1-ed99-434f-a406-f10a51c9a058","timestamp":"2023-05-08T10:41:54.524924"},"records":[{"nodeCode":"1018","capacityBucket":"F2DA","shipVia":"32DA","providerName":"FedEx","nikeServiceLevelCode":"2DA","channel":"DIGITAL","capacities":[{"id":"bbf99dfd-92fb-4096-9788-87eb1d54ea51","maxCapacity":340,"date":"2023-05-03"}]}]}
'
}
],
"priority": "string"
}
Hello @noebernal ,
You are right, this is a known issue following 2024.2 release.
To solve it you need to replace the single quotes with double quotes around your JSON string in the "value" field. Hence, this should work:
{
"questions": [
{
"name": "Input",
"value": "{\"event\":{\"id\":\"ff99d0e1-ed99-434f-a406-f10a51c9a058\",\"timestamp\":\"2023-05-08T10:41:54.524924\"},\"records\":[{\"nodeCode\":\"1018\",\"capacityBucket\":\"F2DA\",\"shipVia\":\"32DA\",\"providerName\":\"FedEx\",\"nikeServiceLevelCode\":\"2DA\",\"channel\":\"DIGITAL\",\"capacities\":[{\"id\":\"bbf99dfd-92fb-4096-9788-87eb1d54ea51\",\"maxCapacity\":340,\"date\":\"2023-05-03\"}]}]}"
}
],
"priority": "string"
}
