Anaplan API WADL

Highlighted
Occasional Contributor

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 

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

Re: Anaplan API WADL

@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" : ","
}

Jared Dolich
Highlighted
Occasional Contributor

Re: Anaplan API WADL

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

Highlighted
Master Anaplanner/Community Boss

Re: Anaplan API WADL

@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...

 

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...


Jared Dolich
Highlighted
Occasional Contributor

Re: Anaplan API WADL

Thats brilliant thants for your help.

Cheers d0nmac