JSON formating String

Question

I have a pipeline that uses the ServiceNow API Snap to retrieve data about ServiceNow Tasks.  The Snap returns the data and I pass through a mapper.
However the ServeirNow form that I am getting data from contains ServiceNow custom variables and these come back from the API as a string and I am struggling to get these into a JSON format.
This is the data after the mapper
{
“number”:“RITM123456”
“etc:123”
“variables”:“Auto ID = 123
 Autoversion ID = 345
 Autoname = SQL stuff
 etc…”
}
I have tried using split and replace, but I cannot get the data into the right format.
How do I get everything into a JSON format?

alchemiz · Answer

You can use the .toObject method of the array

peter · Answer

Thanks very much.
I dont understand how the toObject works.
When I use the code I get an error for one record;
Cannot access element 1 of ‘x.split(’=‘)’, which has only 1 elements,
The issue seems to be with a description field which has line returns, i.e.
Description = Great things
are a foot
The code is expect a new field after the 
 hence do I need to replace the 
 with a space?
Is there a good way to do this?

peter · Answer

I am nearly there with my pipeline however I now have “nested” JSON, that is the first set of JSON returned by the API and the variables.  Is there a way to flaten so that I have a single level of JSON?
I now have:
{
“number”:“RITM123456”,
“etc:123”,
variables : {
“Auto ID : 123”
“Autoversion ID : 345”
“Autoname : SQL stuff”
}
}
And I would like
{
“number”:“RITM123456”,
“etc:123”,
“Auto ID : 123”
“Autoversion ID : 345”
“Autoname : SQL stuff”
}
}

stevegoodwin · Answer

Looks like all you need is a mapper snap.

alchemiz · Answer

Or in the scenario wherein the objects inside the variables object is dynamic you can always use the merge then filter variables to destroy the variables object 😄

Forum Discussion

JSON formating String

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?