D) Updating Data through an API (PUT, PATCH Requests)
Previous article: Creating Records through an API (POST Requests)
Step 1. You can copy-paste the Data Flow Task component you've used to create a record for a resource or create a new one in the same way we did in the previous article.
Step 2. Modify the component's JSON Source payload to reflect the changes you'd like to make to the record we'll specify by its ID. Here I am going to change the name and description of my ClickUp task, but the tag will stay the same.
Step 3. Get your task ID from the ClickUp browser interface by selecting the "more options" ellipsis on a list's task and clicking "Copy ID". Paste it into the JSON Source and remove the hashtag (#). Click OK when you're done.
Step 3. Open the REST Destination editor. Select Update as the action and once again, you'll need to specify the list_id for this example.
Step 4. Select the mapping tab to make sure that your fields/columns are mapped correctly. In some cases, you may need to refresh the columns, unmap all, and map all using the buttons at the top.
Step 5. Execute the component. You should now see your updated task item in ClickUp!
Next article: Deleting Data from an API (DELETE Requests)
Book a Presales Call
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
E) Deleting Data from an API (DELETE Requests)
Section table of contents: Section Table of Contents Previous article: Updating Data through an API (PUT, PATCH Requests) Step 1. Copy-paste the Data Flow Task used for updating data through the API. Step 2. Open the JSON Source component and modify ...C) Creating Records through an API (POST Requests)
Section table of contents: Section Table of Contents Previous article: Reading Data from an API (GET Requests) Step 1. You should now be proficient with setting up an Integration Services Project in Visual Studio and reading data from an API with ...Getting Started with REST API Connections in CozyRoc SSIS+: Section Table of Contents
Guide table of contents: Guide to REST API Connections in CozyRoc SSIS+ Get acquainted with REST API connectors in CozyRoc SSIS+ so that you can integrate data sets and databases across web services and platforms. CozyRoc SSIS+ Components Suite is a ...Guide to REST API Connections in CozyRoc SSIS+: Table of Contents
Table of Contents I. Introduction II. Installing CozyRoc SSIS+ A) Installing Visual Studio and SSDT B) How to Download and Install the CozyRoc SSIS+ Components Suite C) Check Software Versions D) Licensing CozyRoc SSIS+ III. The Basics of SSIS+ IV. ...B) Reading Data from an API (GET Requests)
Section table of contents: Section Table of Contents Previous article: Configuring a REST Connection Manager In this article: Part 1: Listing Records Part 2: Composite Columns Part 1: Listing Records Step 1. Once you have created a REST Connection ...