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

[Arif6]

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!

[Ankur Bawiskar]

@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

[Munny1]

hi Ankur

can u please check i am trying with u r logic

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