Trying to use Zoho Flow to trigger on new sales orders coming from Amazon Seller Central. I am able to see the data, but need help on parsing the long string that comes across with "Sales order created" trigger.
The field being mapped to variable is:
${trigger.line_items}
The return value is:
[{"line_item_id":"9999999999999999","discount_amount":0,"item_type":"inventory","item_type_formatted":"Inventory Items","discount":0,"document_id":"","quantity_cancelled":0,"image_name":"","product_id":"9999999999999999","attribute_option_name2":"","attribute_option_name3":"","is_returnable":false,"sku":"product1","pricebook_id":"","image_type":"","attribute_name2":"","tax_exemption_code":"AMAZON US- CUSTOMERTAXEXEMPTION","attribute_name3":"","bcy_rate_formatted":"$19.99","image_document_id":"","attribute_name1":"","item_total":19.99,"tax_id":"","tags":[],"unit":"unit","tax_type":"tax","name":"my product","item_sub_total_formatted":"$19.99","discount_amount_formatted":"$0.00","bcy_rate":19.99,"item_total_formatted":"$19.99","is_combo_product":false,"quantity_shipped":0,"quantity_returned":0,"rate_formatted":"$19.99","header_id":"","quantity_invoiced_cancelled":0,"attribute_option_data3":"","description":"","attribute_option_data2":"","attribute_option_data1":"","item_order":0,"is_unconfirmed_product":false,"item_sub_total":19.99,"variant_id":"9999999999999999","rate":19.99,"quantity_packed":0,"quantity":1,"quantity_manuallyfulfilled":0,"item_id":"9999999999999999","attribute_option_name1":"","tax_name":"","header_name":"","item_custom_fields":[],"tax_exemption_id":"9999999999999999","is_invoiced":false,"quantity_invoiced":0,"tax_percentage":0}]
As you can see this is JSON of some sort, but I am not so clear on how to parse the data out of this returned value.
Thanks for any help available.