I'm attempting to parse a http response to JSON and from there use it to send a notification (currently using Teams, doesnt really matter what the service is.
In the results after a flow runs you can see the original content, the schema (generated by either flow or an external service) and the body containing the results. This is all as expected. When it is output however the dynamic content placeholders, all named correctly from the schema/data, only return null values.
The original JSON content exactly as it arrives (i've adjusted phone numbers and some SIDs in the data for privacy):
{"smsjson":{"ToCountry":"AU1","ToState":"1","SmsMessageSid":"SMe817731ef923413ab2de7c804e61b4f11","NumMedia":"01","ToCity":"1","FromZip":"1","SmsSid":"SMe817731ef923413ab2de7c804e61b4f11","FromState":"1","SmsStatus":"received1","FromCity":"1","Body":"Response catch 41","FromCountry":"AU1","To":"+614","ToZip":"1","NumSegments":"11","MessageSid":"SMe817731ef923413ab2de7c804e61b4f11","AccountSid":"1","From":"+614","ApiVersion":"2010-04-01"}}
The JSON Schema, NB this example uses a schema generated at the URL shown, same results occur if i use the built in schema generator.
{
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "http://example.com/example.json",
"definitions": {},
"type": "object",
"properties": {
"smsjson": {
"type": "object",
"properties": {
"AccountSid": {
"type": "string"
},
"ApiVersion": {
"type": "string"
},
"Body": {
"type": "string"
},
"From": {
"type": "string"
},
"FromCity": {
"type": "string"
},
"FromCountry": {
"type": "string"
},
"FromState": {
"type": "string"
},
"FromZip": {
"type": "string"
},
"MessageSid": {
"type": "string"
},
"NumMedia": {
"type": "string"
},
"NumSegments": {
"type": "string"
},
"SmsMessageSid": {
"type": "string"
},
"SmsSid": {
"type": "string"
},
"SmsStatus": {
"type": "string"
},
"To": {
"type": "string"
},
"ToCity": {
"type": "string"
},
"ToCountry": {
"type": "string"
},
"ToState": {
"type": "string"
},
"ToZip": {
"type": "string"
}
}
}
}
}
And the body from the results (see screenshot):
{
"smsjson": {
"ToCountry": "AU1",
"ToState": "1",
"SmsMessageSid": "SMe817731ef923413ab2de7c804e61b4f11",
"NumMedia": "01",
"ToCity": "1",
"FromZip": "1",
"SmsSid": "SMe817731ef923413ab2de7c804e61b4f11",
"FromState": "1",
"SmsStatus": "received1",
"FromCity": "1",
"Body": "Response catch 41",
"FromCountry": "AU1",
"To": "+614",
"ToZip": "1",
"NumSegments": "11",
"MessageSid": "11",
"AccountSid": "1",
"From": "+614",
"ApiVersion": "2010-04-01"
}
}
I'm by no means an expert here, fairly sure i've missed something obvious so happy to receive any advice!
