By using PATCH method in REST API need to update field values on two different tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-20-2018 03:17 AM
By using PATCH method in REST API need to update field values on two different tables over single payload, like for service catalog need to update few variables on custom table and stage field on global table.From 3rd party tool to SNOW,Can you please help/guide me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-20-2018 04:57 AM
Can you provide some additional detail about what you have tried?
Please note, if you are updating two tables, you will need two different HTTP requests to two different endpoints if you are using the table API.
If you want to do this in one call, you will need to write your own scripted REST API which puts you in total control of inputs, outputs, and processing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-20-2018 05:48 AM
I created PATCH method in scripted rest API, im not getting the idea on script.
Should need to glide the two tables in script?? Can you please guide me
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-20-2018 05:59 AM
Yes, you will need to use GlideRecord to update the records on the tables yourself from within the scripted REST API. I recommend reviewing the docs for more information. Me typing the same thing here doesn't add value.
I also invite you to watch this video we did on TechNow about scripted REST APIs a couple years ago.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-21-2018 02:36 AM
Hello..
In scripted web-service , if we glide two tables in script but in endpoint have to select only one table then how its update will done on other table??
