Insert and delete data in Anaplan

VinothKumar91

Hi Team ,

I'm trying to insert and delete data into Anaplan using below API.

Insert :

Delete :

Is it the right API to insert and delete ?

How can I get the Data's task id ? and how to ensure the insertion and deletion of data in Anaplan

Thanks in advance

Regards,

Vinoth Kumar K.

Accepted answers

Badam

Hi Vinoth,

For inserting data into the list, your choice of API is correct. But it is just one part of the API, There are a series of APIs you need to run for importing data into the system.

Upload files.
Get the import ID and Start the import.
Monitor each import task using the ID that was returned when you started the import. If you are importing a large file, it might take some time depending on the way in which you import it.
Check for failures in each import task when the import is complete.

You can refer the link: https://anaplan.docs.apiary.io/#/reference/import

I hope the above information is helpful to you. If you need any clarification, please let me know.

Thanks & Regards

Badam Anjani Prasad

Matasma Digital

All comments

ryan_kohn

There are two main approaches to managing data in Anaplan via API.

Bulk API: This requires building and design "actions" in Anaplan as a model builder, and then triggering those actions via API. Read more here: https://help.anaplan.com/93218e5e-00e5-406e-8361-09ab861889a7-Use-the-bulk-APIs
Transactional API: This allows inserting, exporting, or deleting data in Anaplan without needing to create actions in Anaplan. Read more here: https://community.anaplan.com/t5/How-To/Start-Here-Transactional-APIs-Part-1-The-Basics/ta-p/110120

In both cases, you will need to either understand the data and structure of the model yourself, or work with a model builder/solution architect on your team that does.

Hope the above info helps!

Badam

Hi Vinoth,

For inserting data into the list, your choice of API is correct. But it is just one part of the API, There are a series of APIs you need to run for importing data into the system.

Upload files.
Get the import ID and Start the import.
Monitor each import task using the ID that was returned when you started the import. If you are importing a large file, it might take some time depending on the way in which you import it.
Check for failures in each import task when the import is complete.

You can refer the link: https://anaplan.docs.apiary.io/#/reference/import

I hope the above information is helpful to you. If you need any clarification, please let me know.

Thanks & Regards

Badam Anjani Prasad

Matasma Digital

VinothKumar91

Hi @Badam ,
Thanks 🙂 Your solution really helped me a lot.
I could able to upload the file and import into anaplan.

I tried out Anaplan connect to export and import data in Bulk via JDBC connectivity.

I get below error , Can you share me some sample scripts for Export and Import data ( JDBC )

Regards,
Vinoth Kumar K.

VinothKumar91

Hi @ryan_kohn

Thanks Ryan , I opted for Bulk API approach.

It was very helpful and I could able to export and import data into Anaplan.

I'm trying out Anaplan Connect with JDBC Connectivity (To import and Export Data). I face below issue. can you guide or share me some sample scripts to import and Export.

Regards,

Vinoth Kumar K.

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?