NEW: Check our new hosted service COZYROC Cloud ...
ClickUp Connection
Overview
Configuration is provided for establishing connections with ClickUp service. The configuration is used in the REST Connection Manager.
Setup
Press icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Quick Start
In this task, we will show you step-by-step how to create a connection to Stripe ClickUp API using COZYROC's REST Connection Manager.
Step 3. If you have set the Authentication parameter to Token then in the grid below specify the API Token for parameter Token which can be retrieved from url : https://app.clickup.com/25732496/settings/apps
. Then click on Test Connection to see if you have a successful connection or not to the ClickUp service and Ignore the steps 4 to 9. If the Authentciation parameter is set to OAUTH 2 then follow the steps 4 to 9 for successfuly generating the token file.
Step 7. Paste the url in the token generation wizard we copied in the previous step and click on next button.
Congratulations! You have now established a connection to your ClickUp instance.
In this guide, we will show how to read data from the ClickUp service resource using the COZYROC REST Source component.
In this guide, we will show how to write data to the ClickUp service resource using the COZYROC REST Destination component.
Configuration
The provided configuration handles the authentication aspect of communicating with the service. To invoke endpoints, specific to you integration needs, consider defining custom resources (to be used with REST Source and/or REST Destination) or use the REST Web Service Request Task. If you have suggestions for further improvements, we will be happy to hear your feedback.
Download the configuration from here. Then review the KB article posted here how to use the configuration.
Base URL address: https://api.clickup.com/api/v2
.
- OAuth 2
-
The authentication uses an authorized token.
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
For further information, please check here.
-
Authorization:
- Token
-
The authentication uses a parameters-based authentication.
The authentication has the following user-defined parameters:
- Token:
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
{{=connection.user.Token}}
For further information, please check here.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Date
Data type: DT_DBDATE
- Boolean
Data type: DT_BOOL
- Number
Data type: DT_R8
- [Read] action
-
The result is extracted from:{{=response}}
.
The result is paginated.The following request parameters will be automatically processed:
-
pages:
{{=parameters.iterator}}
-
maxPage:
{{=parameters.batchSize}}
-
_includeUserParameters:
{{=parameters}}
-
pages:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
application/json:
{{=item}}
-
_includeUserParameters:
{{=parameters}}
-
application/json:
- [Update] action
-
The action uses PUT method.The following request parameters will be automatically processed:
-
application/json:
{{=item}}
-
_includeUserParameters:
{{=parameters}}
-
application/json:
- [Delete] action
-
The action uses DELETE method.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.