import { axios } from "@pipedream/platform"; export default { key: "servicenow-update-table-record", name: "Update Table Record", description: "Updates the specified record with the name-value pairs included in the request body.", version: "0.1.2", annotations: { destructiveHint: true, openWorldHint: true, readOnlyHint: false, }, type: "action", props: { servicenow: { type: "app", app: "servicenow", }, table_name: { type: "string", description: "The name of the table containing the record to update.", }, sys_id: { type: "string", description: "Unique identifier of the record to update.", }, update_fields: { type: "object", description: "An object with name-value pairs with the fields to update in the specified record.\n**Note:** All fields within a record may not be available for update. For example, fields that have a prefix of \"sys_\" are typically system parameters that are automatically generated and cannot be updated.", }, api_version: { type: "string", description: "API version number. Version numbers identify the endpoint version that a URI accesses. By specifying a version number in your URIs, you can ensure that future updates to the REST API do not negatively impact your integration. Use `lastest` to use the latest REST endpoint for your instance version.", optional: true, options: [ "lastest", "v1", "v2", ], }, request_format: { type: "string", description: "Format of REST request body", optional: true, options: [ "application/json", "application/xml", "text/xml", ], }, response_format: { type: "string", description: "Format of REST response body.", optional: true, options: [ "application/json", "application/xml", "text/xml", ], }, x_no_response_body: { type: "boolean", description: "By default, responses include body content detailing the modified record. Set this request header to true to suppress the response body.", optional: true, }, sysparm_display_value: { type: "string", description: "Return field display values (true), actual values (false), or both (all) (default: false).", optional: true, options: [ "true", "false", "all", ], }, sysparm_fields: { type: "string", description: "A comma-separated list of fields to return in the response.", optional: true, }, sysparm_input_display_value: { type: "boolean", description: "Flag that indicates whether to set field values using the display value or the actual value.\n* `true`: Treats input values as display values and they are manipulated so they can be stored properly in the database.\n* `false`: Treats input values as actual values and stored them in the database without manipulation.", optional: true, }, sysparm_view: { type: "string", description: "Render the response according to the specified UI view (overridden by sysparm_fields).", optional: true, options: [ "desktop", "mobile", "both", ], }, sysparm_query_no_domain: { type: "boolean", description: "True to access data across domains if authorized (default: false).", optional: true, }, }, async run({ $ }) { if (!this.table_name || !this.sys_id || !this.update_fields) { throw new Error("Must provide table_name, sys_id, and update_fields parameters."); } var apiVersion = ""; if (this.api_version == "v1" || this.api_version == "v2") { apiVersion = this.api_version + "/"; } return await axios($, { method: "patch", url: `https://${this.servicenow.$auth.instance_name}.service-now.com/api/now/${apiVersion}table/${this.table_name}/${this.sys_id}`, headers: { "Authorization": `Bearer ${this.servicenow.$auth.oauth_access_token}`, "Accept": this.request_format || "application/json", "Content-Type": this.response_format || "application/json", "X-no-response-body": this.x_no_response_body, }, params: { sysparm_display_value: this.sysparm_display_value, sysparm_fields: this.sysparm_fields, sysparm_input_display_value: this.sysparm_input_display_value, sysparm_view: this.sysparm_view, sysparm_query_no_domain: this.sysparm_query_no_domain, }, data: this.update_fields, }); }, };
Chase Roberts@chsrbrts@benedictevans If you haven’t used @pipedream yet, then you haven’t lived.
✨Ellie Day✨@heyelliedayEvaluation update: @pipedream has quite literally been a dream to work with! I’m excited to leverage this tool for all the various workflows I need to write. I’m currently at 11k invocations a day from the initial workflows I’ve written in the past couple weeks.
Michael Braedley@MBraedleyUpdate: I got it working properly, and it's working so well that I'm dropping IFTTT. @pipedream can do everything that IFTTT basic can, and most (if not all things) IFTTT pro can for free or at a reasonable price if you need it. I am recommending it for basically any power user.
Thomas Cutting@mrthomascuttingWant quick+dirty integrations for a serverless workflow - @pipedream is my new go-to 😃
Matthew Roberts@mattdotrobertsday 013 - finally hit node js. This is the secret sauce of taking #nocode projects that one step further. Pumped about getting deeper into @pipedream now
Kenneth Auchenberg 💭@auchenbergYahoo Pipes is back! Kinda 😍 @pipedream
Raymond Camden 🥑@raymondcamdenAwesome video by the @pipedream folks showing real time twitter sentiment analysis integrated with Google Sheets. This is where Pipedream *really* shines, connecting systems together in easy workflows.
Nacho Caballero@nachocaballeroI couldn't recommend @pipedream more. It's an amazing service to integrate different APIs. Much more powerful than Zapier and more user-friendly than AWS Lambda. I'm very proud to wear this t-shirt #NoCode
Jason Snow@jyksnwDeveloped a working prototype environmental sensor IoT solution with @particle Photon, @pipedream, and @MongoDB with full graphing and alerting in less than a day! All amazing technology, will def. be exploring these more.
Steven Terrana@steven_terrana@burgwyn you've inspired me to finally set up my own blog. I'll make sure my first blog post explains the tech behind the setup. think @obsdmd + @GatsbyJS + @pipedream.
🚄 James Augeri, PhD@DotDotJamesWant to low-code your back end, need more horsepower than @Bubble / @KnackHQ, or just miss Yahoo! Pipes? Check out @PipeDream
Sébastien Chopin@AtinuxGitHub issues should be like @linear_app for maintainers. Looking forward more integrations with GH actions or tools like @pipedream 👀
Raul@raul_predescuIf you're a dev and not using @pipedream, you're missing out. Been using it for months, daily. FREE for devs. Plenty of integrations and good limits. Absolutely love it.
Bruno Skvorc@bitfallsSo @pipedream is pretty amazing. In 3 minutes I just made a flow which adds @rickastley's Never Gonna Give You Up to my @spotify playlist whenever a new pull request arrives in an old repo of mine.
Zach Lanich@ZachLanichUm, wow 🤯 @pipedream
Steven Bell@bellontechI just used @pipedream to build a Shopify App. Wow, they make small backed tasks easy.
Jay Hack 🎩🇺🇸@_jayhack_Very impressed with this bad boi - it reminds me of a @PalantirTech internal tool, but geared towards integrations instead of data analysis and far more customizable. Great expectations here 🚀🤩
Tree Sturgeon 🔥🚴♂️🌳@philsturgeonFor context this is day 2 of a really challenging and stupid migration from Notion to @airtable with disparate/missing data. It's going better than expected and thanks to @pipedream I don't have to bother the iOS dev to add W3W.