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
Best Answer
-
Sounds great!
Try installing the JSON adapter for SAP data services.
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.
3
Answers
-
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" : ","}0 -
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
0 -
Thats brilliant thants for your help.
Cheers d0nmac0