cancel
Showing results for 
Search instead for 
Did you mean: 

ServiceNow json format

Raj
New Contributor II

I am trying to load ServiceNow data to Redshift. Looks like there are no read snaps available. Got the data to S3 using curl in the json format. Looks like json parser is not parsing the data correctly. Child records are at level 3. I put in a mapper to get the data and associate it to target. After saving and validating, I cannot see the data in Table format. Shows only in Json format.

What am I doing wrong?

1 REPLY 1

Raj
New Contributor II

Got this resolved. I had to put in a json splitter before mapper since the json data I was getting had multiple levels.