cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member609316
Discoverer
0 Kudos

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

Accepted Solutions (0)

Answers (5)

Answers (5)

CarenFernandes
Explorer
0 Kudos
Hello everyone,Apologies for the delayed response and not providing it in a timely manner. It has come to our attention that the request API requires a header with the content-Type "Application/Octed-Stream". We have already raised an OSS ticket, and SAP has confirmed that there is no header of "Application/Octed-Stream" available in HCI for the REST connections at that moment of time.
shodhan
Explorer
0 Kudos

Hi Caren,

Can you share the solution here.

Regards,

Shodhan

former_member663258
Discoverer
0 Kudos

Hi Caren,

164900 / 2019 Connect to REST API through CPI-DS to upload the data.--Is not accessible via Launch pad.

Could you tell us what was the solution for this

Thanks,

Guru

0 Kudos

Hi Caren ,

We are also trying the same scenario to connect to REST api through CPI/DS for Anaplan but the oss message that you have mentioned is very specific to your company and we do not have access to the same .
would really appreciate if you could share the details what was the solution on the oss message and this oss message is not an oss note .

Thank you

Sri

former_member550616
Discoverer
0 Kudos

Hi Caren,

We too have similar requirement to export data from Anaplan. Have you resolved this issue?

First thing for me is to generate a WADL file, but I'm not sure how to do that and people for Anaplan say they don't have one. Can you let me know how you got this?

Thanks in advance.

Keshav

former_member609316
Discoverer
0 Kudos

Hi Keshav,

We have generated the WADL via SOAP UI. You can use SOAP UI to generate the WADL.

Also we have created a SAP Incident for the issue faced, you can go through the Incident to get details. PFB the Incident details.

Incident details: 164900 / 2019 Connect to REST API through CPI-DS to upload the data.

Regards,

Caren