Skip to Content
0
Apr 08, 2019 at 05:16 AM

Connect to REST API through CPI-DS to upload the data.

1183 Views

Hi All,

We have a requirement to connect to the cloud system Anaplan through CPI-DS using REST API to upload the data (https://anaplanbulkapi20.docs.apiary.io/# ).We have tested the connectivity with Anaplan through an external tool Postman which was successful. We configured the same in CPI DS datastore but we are not able to establish the connectivity.

We have tried configured the datastore with the Anaplan API URL but we are getting the following error during the connection test.

Test failed for the default configuration 'default' of datastore: 'Anaplan_GET':

HTTP client error:<35>:<SSL connect error>.

We have tried configuring the datastore with WADL file and we were able to import the structure but when we run the task we are getting the following error.

2019-03-21 16:03:22 (E)(4468:4828) RUN-248056 |Data flow Rest_Demo_Rest_Demo|Transform Target_Web_Service_Call-Function1

HTTP client error:<3>:<URL using bad/illegal format or missing URL>.

2019-03-21 16:03:33 (E)(6924:2096) RUN-248056 |Data flow Rest_Demo_Rest_Demo|Transform Target_Web_Service_Call-Function1

HTTP client error:<3>:<URL using bad/illegal format or missing URL>.

We also have a requirement to configure the Anaplan REST API URL in CPI-DS which contains dynamic parameter as the part of the URL. Since the connectivity is not working we are not able to check this dynamic parameter in the URL.

PFB the URL:

URL: https://api.anaplan.com/1/3/workspaces/WorkspaceID/models/ModelID/files/FileID/chunks/ChunkID

Here, the ChunkID is variable (i.e: 0,1,2...) based on the number of chunks while uploading data to Anaplan. Could you please let us know if this can be configured in CPI-DS datastore.

Kindly let us know if someone could help us with this.

Regards,

Caren