How to parse JSON response in REST API | 4MV4D | S01L13

[@DipakKumar-ls7dk]

Knowledgeable video, Awaiting for the second part in which you will insert the data into import set table and use the business rule to insert into target table.

[@NiamulArifin]

Very good videos on integration. Subscribed. Waiting on the next videos.

[@우한균]

Perfect Video man, It's really helpful.

[@seasuccesschannel2628]

Good one

[@SAASWithServiceNow]

Thanks. Please share my Channel and Videos and don't forget to Subscribe.

[@amirmohamed4670]

Thank you so much! A very informative and amazing video.

[@mahendrapulakam4525]

Thanks Gaurav all the videos , really help for developers

[@noor-ul-ainatta802]

Thanks for increasing my knowledge. I have one instance only on my email, Can I just take any dummy data from internet or test data to test it in my PDI for the practice?

[@trudyandgeorge]

Video starts at <a href="#" class="seekto" data-time="1525">25:25</a> Spoiler: JSON.parse()

[@SIRReddy]

Very good explanation.

[@SAASWithServiceNow]

Glad it was helpful!

[@govinddhande5717]

@SAASWITHSERVICENOW, how do know whether or not the response is in Array? I am having issues where I am getting response in variables but HTML fields are coming as undefined, so can't create or update the record

[@shivam.1764]

Great!!

[@ajaykumaryellanki2099]

Hi sir i have a small requirement Coalesce property use number field and importing records into target table but i don't want to update records then I want create records.? Would you explain pleas

[@samuraiwolf3669]

"the 📢four📢 minut video" <a href="#" class="seekto" data-time="1860">31:00</a> what a moment

[@indrajapandiri3922]

I have a glidelist type field which is returning the sys_id's of the user's but the sys_id's are different both instances so I need the user ID of the sys_id which I can't get through the dot walking can anyone have any suggestions?

[@edsel816]

What's the website name that you used to make the json result look cleaner?

[@SAASWithServiceNow]

www.freeformatter.com/json-formatter.html

[@samueltse6985]

came across your SNow videos and they are very informative. I have a question about parsing REST response. What if the response comes back in gzip format? Is there a way to parse it in SNow? It seems to be getting more common that third-party companies are compressing their response due to the size. Any thoughts on that?

[@SAASWithServiceNow]

I have never tried gzip. Let me try that.

[@varshaamin8053]

Hi, Thanks for this video. Could you please explain how can I log the reference field value for example: model_category - Computer just like how you logged asset tag value.

[@SAASWithServiceNow]

You can use sys_display_value=true parameter or you can change the returned fields in api explorer and select category .name which will return model category name in JSON and then you can get that value.

[@abdulla14886]

Waiting for next video on json parse....

[@SAASWithServiceNow]

Did it not help?

[@abdulla14886]

You have missed a important thing,! writing those parsed json in to a staging table / target table.

[@veerabhaskardonikela2158]

@MF Sohail khilji R u find the next vedio Creating records in target table

[@seasuccesschannel2628]

Already subscribed... Commented... Let me share with friends...

[@chinmaytawade1607]

Thanks!

[@gayathrishivakumar3893]

Good one