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 CozyRoc SSIS+. You should have a REST Connection Manager connected to ClickUp (or your particular API service) in the bottom panel. Open the SSIS Toolbox panel on the left-hand side, create a Data Flow Task, and go to the Data Flow screen for that component.
Step 2. Open the SSIS Toolbox and add two components, JSON Source and REST Destination, to the Data Flow screen. You will see a red "X" indicator on each new component because they are not yet configured.
Step 3. Open the REST Destination component. Here you will select the connection manager you've created, define your action ("Create"), and select the resource. We're using the Task resource in ClickUp for this example. Batch size is not relevant for most "create" requests unless it is a batch-processing API. Specify the list identifier,
list_id, for this example. As discussed in Reading Data from an API (GET Requests), you can use the end of the URL when viewing a list in the ClickUp browser UI.
Step 5. Click OK and connect the JSON Source arrow to the REST Destination. In the Input Output Selection, select "JSON Source Output" as the output and "Task" as the input.
Step 6. Click OK and re-open the REST Destination editor. Now you can go to the Mapping tab. You should see that your three input fields (tag, name, and description) are automatically mapped to destination columns by the same name. These mappings are visible in the table at the bottom and the line-connector display at the top. Mapping provides you with some flexibility in how to write your JSON source data.
Step 7. For this step, we'll execute the task component to create a task item in ClickUp! Save your work and go to the Control Flow. Execute the task. After Visual Studio submits the request successfully, you should see a green checkmark on the component. If there's an error, you can see details toward the bottom of the Execution Results or Progress tab.
Next article: Updating Data through an API (PUT, PATCH Requests)