E) Deleting Data from an API (DELETE Requests)
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 the JSON data to include only "id" and "name". The ID identifies the record we'd like to delete, and "name" is a field used as a placeholder for data to be sent in the DELETE request body. You can enter anything for the name.
This is where the API documentation for a particular web service typically differs from CozyRoc software's method.
Step 3. Delete unmapped input columns from the previous step using the checkbox in the bottom left corner of the screen opened by clicking the arrow with the red "X" indicator between Data Flow components. You may also use the top buttons in the REST Destination editor for this.
Step 4. Open the REST Destination editor to change the action to Delete. Ensure that the "id" and placeholder columns are mapped. Execute the Data Flow Task from the Control Flow. The item should now be deleted.
D) Updating Data through an API (PUT, PATCH Requests)
Section table of contents: Section Table of Contents 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 ...
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 ...
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. ...
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 ...