JSON Build

MD2050

Hello Everyone - 

Reaching out to the community to seek some assistance in building the below JSON string for PATCH updates to be able to pass to an API call . We had a similar instance where the JSON was not that complex as below and we were able to build that however we are having issues building the below structure , please note the fields in blue will be JSON_ValueString that will be passed dynamically for updating several contacts (we built an iterative macro that was called inside the actual AWF in the previous task assigned to us). Please if possible suggest the tools which are compatible with 2019.3 version of Alteryx server & desktop application. Greatly appreciate any help. Thank you very much in advance.  

{
"Contacts": {
"Items": [
{
"ElectronicAddress": "abc.test@domain.com",
"EffectiveStart": "2022-04-10",
"ContactsInformationType": {
"ContactsInformationTypeGroup": {
"Code": "ElectronicAddress"
},
"Code": "BusinessEmail"
}
}
]
}
}

MD

MD2050

Hello @Luke_C 

Thank you for your reply . We were able to construct the JSON using the same steps , below snippet shows the same and the output of the below AWF is in blue text which is what was needed. We were also able to get the PATCH call working with a HTTP 200. Thank you all very much.

{"Contacts":{"Items":[{"ElectronicAddress":"abc.test@domain.com","EffectiveStart":"2022-04-10","ContactInformationType":{"ContactInformationTypeGroup":{"Code":"ElectronicAddress"},"Code":"BusinessEmail"}}]}}