How to create scripted rest api post data through transform maps

AJAYKUMAR G
Tera Contributor

How to create scripted rest api post data through transform maps

1 ACCEPTED SOLUTION

Tushar
Kilo Sage
Kilo Sage

Hi @AJAYKUMAR G  You can use scripted rest api to accept JSON data, determine which Workday integration type applies and insert data into the Import Set Table after that trigger the correct Transform Map.

something like this -
Third-party system sends API request
Scripted REST API receives the request
Inserts the record into the Import Set Table
Manually triggers the correct Transform Map
Transform Map processes and moves data to the target table

 

Thanks.

 

View solution in original post

5 REPLIES 5

AJAYKUMAR G
Tera Contributor

there are 3 different transform maps designed for worday integration. based workday integration we need post data from scripted rest api source.

Ankur Bawiskar
Tera Patron
Tera Patron

@AJAYKUMAR G 

so 3rd party will consume scripted REST API and then based on payload received you can insert data into the correct source import set table

Once record is inserted into that import set table the transform map associated with that source table will kick off

where are you stuck?

If my response helped please mark it correct and close the thread so that it benefits future readers.

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

How to create  scripted REST API and then based on payload received.

Tushar
Kilo Sage
Kilo Sage

Hi @AJAYKUMAR G  You can use scripted rest api to accept JSON data, determine which Workday integration type applies and insert data into the Import Set Table after that trigger the correct Transform Map.

something like this -
Third-party system sends API request
Scripted REST API receives the request
Inserts the record into the Import Set Table
Manually triggers the correct Transform Map
Transform Map processes and moves data to the target table

 

Thanks.