Anaplan API WADL

Hi ,

We are looking to use the anaplan api with one of our ETL tools which allows us to setup a connection using a rest connection, however it's looking for a WADL. Is this something that exists or will we need to create this ourselves.

Thanks D0nmac

Accepted answers

JaredDolich

@D0nmac

Sounds great!

Try installing the JSON adapter for SAP data services.

https://blogs.sap.com/2012/07/17/jsonadapter-for-data-services-helps-to-bring-unstructured-text-data-into-sap-ecosystem/

ETL standardization is an absolute requirement in my mind, especially if you are trying to automate the imports and exports.

You can do this with SAP Data Services but you'll need to be patient and work it out.

Anaplan will only send unordered JSON responses.

However, the actual file you download can be CSV, text, or Excel format. Just keep in mind that the file will be "chunked" into approx. 12MB each so you'll need to iterate. Again, try reading the API documentation. It's actually really well written.

https://help.anaplan.com/anapedia/Content/Data_Integrations/Anaplan_API_Guide.html

Oh, on a side note, I recommend you get a CA certificate. This will save you some trouble with authentication down the road. Here's a good page that provides known Certificates that work with Anaplan.

https://help.anaplan.com/anapedia/Content/Administration_and_Security/Tenant_Administration/Security/SupportedRootCACertificatesWithAnaplan.htm

All comments

JaredDolich

@D0nmac

Which ETL tool are you using?

If it's Informatica, Dell Boomi, Mulesolft they have built in connectors to Anaplan.

Otherwise, I believe you'll need to use an ETL tool that accept JSON for most of the actions in Anaplan. Python example below.

To export data from Anaplan, the data will come as CSV or Text.

You can read all about the API endpoints and formatting here:

https://help.anaplan.com/anapedia/Content/Data_Integrations/Anaplan_API_Guide.html

Available Files:

[ {

"id" : "113000000000",

"name" : "Forecast_Group.txt",

"chunkCount" : 0,

"delimiter" : "\"",

"encoding" : "ISO-8859-1",

"firstDataRow" : 2,

"format" : "txt",

"headerRow" : 1,

"separator" : "\t"

}, {

"id" : "113000000001",

"name" : "Region.txt",

"chunkCount" : 1,

"delimiter" : "\"",

"encoding" : "ISO-8859-1",

"firstDataRow" : 2,

"format" : "txt",

"headerRow" : 1,

"separator" : ","

}

D0nmac

Hey @JaredDolich

The company wants to try and standardise our ETL as much as possible so we want to try and use SAP Data services, to do out of teh box configuration it looks for a WADL file which I can generate but before spending the time doing it I just wanted to make sure I hadn't missed a premade one somewhere.

Thanks a lot D0nmac

JaredDolich

@D0nmac

Sounds great!

Try installing the JSON adapter for SAP data services.

https://blogs.sap.com/2012/07/17/jsonadapter-for-data-services-helps-to-bring-unstructured-text-data-into-sap-ecosystem/

ETL standardization is an absolute requirement in my mind, especially if you are trying to automate the imports and exports.

You can do this with SAP Data Services but you'll need to be patient and work it out.

Anaplan will only send unordered JSON responses.

https://help.anaplan.com/anapedia/Content/Data_Integrations/Anaplan_API_Guide.html

https://help.anaplan.com/anapedia/Content/Administration_and_Security/Tenant_Administration/Security/SupportedRootCACertificatesWithAnaplan.htm

D0nmac

Thats brilliant thants for your help.

Cheers d0nmac

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…