Azure Logic Apps standard parse JSON error
Whenever I pass a simple JSON and simple schema with the parse JSON card in logic apps something like
{
"Hello":"World"
}
and
{
"type": "object",
"properties": {
"Hello": {
"type": "string"
}
}
}
It processes naturally, but if I try to access the data from an API call from WHMCS GetClientsProducts via an HTTP request I get an error.
schema
{
"type": "object",
"properties": {
"result": {
"type": "string"
},
"clientid": {
"type": "string"
},
"serviceid": {
"type": "string"
},
"pid": {
"type": "string"
},
"domain": {
"type": "string"
},
"totalresults": {
"type": "integer"
},
"startnumber": {
"type": "integer"
},
"numreturned": {
"type": "integer"
},
"products": {
"type": "object",
"properties": {
"product": {
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "integer"
},
"clientid": {
"type": "integer"
},
"orderid": {
"type": "integer"
},
"ordernumber": {
"type": "integer"
},
"pid": {
"type": "integer"
},
"regdate": {
"type": "string"
},
"name": {
"type": "string"
},
"translated_name": {
"type": "string"
},
"groupname": {
"type": "string"
},
"translated_groupname": {
"type": "string"
},
"domain": {
"type": "string"
},
"dedicatedip": {
"type": "string"
},
"serverid": {
"type": "integer"
},
"servername": {
"type": "string"
},
"serverip": {},
"serverhostname": {},
"suspensionreason": {
"type": "string"
},
"firstpaymentamount": {
"type": "string"
},
"recurringamount": {
"type": "string"
},
"paymentmethod": {
"type": "string"
},
"paymentmethodname": {
"type": "string"
},
"billingcycle": {
"type": "string"
},
"nextduedate": {
"type": "string"
},
"status": {
"type": "string"
},
"username": {
"type": "string"
},
"password": {
"type": "string"
},
"subscriptionid": {
"type": "string"
},
"promoid": {
"type": "integer"
},
"overideautosuspend": {
"type": "integer"
},
"overidesuspenduntil": {
"type": "string"
},
"ns1": {
"type": "string"
},
"ns2": {
"type": "string"
},
"assignedips": {
"type": "string"
},
"notes": {
"type": "string"
},
"diskusage": {
"type": "integer"
},
"disklimit": {
"type": "integer"
},
"bwusage": {
"type": "integer"
},
"bwlimit": {
"type": "integer"
},
"lastupdate": {
"type": "string"
},
"customfields": {
"type": "object",
"properties": {
"customfield": {
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "integer"
},
"name": {
"type": "string"
},
"translated_name": {
"type": "string"
},
"value": {
"type": "string"
}
}
}
}
}
},
"configoptions": {
"type": "object",
"properties": {
"configoption": {
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "integer"
},
"option": {
"type": "string"
},
"type": {
"type": "string"
},
"value": {
"type": "string"
}
}
}
}
}
}
}
}
}
}
}
}
}
Even though this schema was generated with the payload that I am requesting for within the HTTP Request prior to the Parse JSON card.
Solution
After reproducing from my end, I faced the similar issue.
This is because the body that is received from trigger body is not of json type (string type). Once I replaced triggedBody() with json(triggedBody()) I could able to get the desired result.
I have taken a sample data from your provided schema and did the same as below.
To make the process easy, First try to select the property that is required.
Then navigate to your code view and replace code as below.
"For_each": {
"actions": {
"Compose": {
"inputs": "@items('For_each')?['customfields']",
"runAfter": {},
"type": "Compose"
}
},
"foreach": "@json(triggerBody())?['products']?['product']",
"runAfter": {},
"type": "Foreach"
}
Results:
- How to return JSON objects without explicit aliasing in postgresql
- jq: assigning to computed property of an object
- is form enctype "application/json" available?
- How do I deserialize JSON in Rust when combining a flattened component with the need to convert keys?
- How to sort order of stacked bar
- How can I parse (read) and use JSON in Python?
- How to recursively print the path of all keys in jq
- Accessing a Variant/Object/JScriptTypeInfo property in VBA
- Using jq to group-concat fields by field name prefix
- How to parse json in flutter Dart
- how to convert json string to json object in dart flutter?
- How Best to Extract Specific JSON Key-Value Pairs in Snowflake
- laravel crashed when I use trait to auto update some values
- Object Serialization to JSON (using Gson). How to set field names in UpperCamelCase?
- How to parse JSON response in filemaker script
- Importing JSON file in TypeScript
- Formatting parameters for C# HttpClient.PostAsJsonAsync
- Swift - Wrong date format (JSON .NET)
- JSON vs JSON Array in .NET Web API - Bandwidth V2
- Jolt transform JSON to different JSON structure
- Is there a way in PHP to strip whitespace from JSON without using ob_gzhandler?
- How can I separate a .json file by keys stored in a different .json file?
- What is the difference between using express.urlencoded() with extended set to true vs set to false + manual JSON stringify/parse calls?
- How to globally set default options for System.Text.Json.JsonSerializer?
- Can I encode and decode a JSON on the GPU using MetalKit?
- Java - Magento2 rest api product upload with image silently fails
- Filtering mysql data using nested json_table returns "Incorrect arguments"
- Can I turn a Pandas Dataframe column containing a jJSON string into additional columns and rows?
- Convert an array of unsigned short to JSON using the nlohmann library
- Redshift COPY with JSON PATH Case Sensitivity