Convert JSON to XML for Related List?
Does anyone have a script example of converting a JSON string to an XML that is usable in a
Related List custom function?
Basically I want to display a list of cases from an external system as a simple table of 4-5 columns, ideally with a link.
I can't even get the sample static XML (from the documentation above)to work -- the script editor just won't save it, maybe because of the quotes.
Any help would be greatly appreciated. JSON snippet below (retrieved using getURL function):
--
{
"total_entries": 2,
"page": 1,
"_links": {
"self": {
"href": "/api/v2/cases/search?email=lizzie%40x.com&page=1&per_page=50&priority=4"
}},
"_embedded": {
"entries": [{
"id": 6276,
"external_id": null,
"blurb": "on Fire! -- TESTING",
"priority": 4,
"created_at": "2016-03-25T16:28:50Z",
"_links": {
"self": {
"href": "/api/v2/cases/6276"
}
}
}, {
"id": 6277,
"external_id": null,
"blurb": "I am creating this case now, and will update it later.",
"priority": 4,
"created_at": "2016-03-25T16:37:56Z",
"_links": {
"self": {
"href": "/api/v2/cases/6277"
}
}
}]
}
}