How to parse JSON response to "Data Source" table ?

Arif6
Giga Contributor

‎06-28-2021 09:29 PM

I have used a REST Message to pull data in JSON format from third party tool Now I want this data in target table in tabular form..how can I do that? I think first I need to push this data to "Data Source" table & then user Transform map to push this data to target table, however, How do I make this JSON data format to "Data Source" table? & also run this API daily to keep pulling data from third party tool & update the target table on daily run Thanks!

Labels:
0 Helpfuls
  • 3,270 Views
6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron
In response to Arif6

‎06-30-2021 04:14 AM

@Arif 

Glad to know.

If my response helped you please mark it correct to close the question so that it benefits future readers as well.

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls

Munny1
Tera Expert
In response to Ankur Bawiskar

‎02-24-2022 03:53 AM

hi Ankur

can u please check i am trying with u r logic

https://community.servicenow.com/community?id=community_question&sys_id=9a0e7726db75cd1007ab826305961944

 

 

0 Helpfuls