Share
Report
8I'm using the Twilio Lookup API that returns a small amount of JSON like that below. What I'd like to do is add a button that will convert the JSON to a single record in a collection.
{
"phone_number": "+15551231234",
"validation_errors": [],
"call_forwarding": null,
"sms_pumping_risk": null,
"url": "https://lookups.twilio.com/v2/PhoneNumbers/+15551231234",
"calling_country_code": "1",
"live_activity": null,
"sim_swap": null,
"caller_name": null,
"national_format": "(555) 123-1234",
"country_code": "US",
"line_type_intelligence": {
"mobile_network_code": "010",
"carrier_name": "Verizon Wireless",
"error_code": null,
"mobile_country_code": "310",
"type": "mobile"
},
"valid": true,
"identity_match": null
}
From what I understand, the ParseJSON function should be able to do it, but I can't seem to get it to work. Even when trying to tweeze out a single field, it doesn't seem to work. The code below keeps trying to add an empty record.
Set(varJsonTest,{ field: Text( ParseJSON( TwilioLookUp.lookup("+15551231234",{Fields:"line_type_intelligence"}).phone_number) ) })
All responses (
Answers (
