Find the import ID from file ID

Hello Experts ,

I'm new to Anaplan and trying to integrate anaplan using Rest API .

We are sending data to anaplan for which I would need an import ID .

However , I have been provided with a file ID by ANAPLAN . Could anyone guide as to how import ID can be retreived from a file ID ?

Also if someone can explain the difference between a file ID /name and an import ID/name , that would help me as well .

Thanks ,

Nitheesh

Accepted answers

All comments

anirudh

Hi Nitheesh,

A file ID begins with 113 and an import ID begins with 112
The two are completely different and it's not possible to find out the import ID from the file ID or vice versa

In case the final objective of your integration is to run a file based import:
you will have to trigger an API request to upload the file using the 113 and then trigger a separate API request to run the import action connected to the said file ID.

Let me know if you need more help

Regards,
Anirudh

Nitheesh

Hi Anirudh ,

Thanks for your quick respose . Really appriciate your help .
I might sound silly with my below question .

My end goal is to transfer a file from an SAP system to ANAPLAN . As far as I understand from the documentation, it is an import action (Sending data to ANAPLAN).

Can I acheive this with file ID ? Or do I need an Import ID as well for the same ?
Also , for my scenario , I have been provided with a file ID and process name. Is there any way I can trigger an Import action using these details ?

Thanks ,
Nitheesh

anirudh

Nitheesh,

Looks like you have access to the Anaplan model itself. If you do, follow the API guide here
https://anaplanbulkapi20.docs.apiary.io/#reference/process and extract the process id. The process name is not enough to trigger it
If you do not have access to Anaplan, then you will have to get the process id first...

Then you will have to trigger two requests, one to upload the file and another to run the process itself. The import id is not required as you have the process id

Regards,
Anirudh

Nitheesh

Hi Anirudh ,

Thank you for being so responsive. Your replies are indeed helping me .

I have now fetched the process ID from anaplan using the process name.
I have the process ID with me now .

Just to get my basics right , As you suggested above , I did run the upload file first using the below command
https://api.anaplan.com/2/0/workspaces/{workspaceId}/models/{modelId}/files/{fileId}
It gave me a 204 response as expected .

Now I have to run the process using below way
https://api.anaplan.com/2/0/workspaces/{workspaceId}/models/{modelId}/processes/{processId}/tasks

But here , My file ID and Process ID are both different and how do they both map internally ? Am I missing something here ?

Thanks ,
Nitheesh

anirudh

So the way the Anaplan API works is on a file upload, the file definition is updated with the file you upload. You can always check the latest file definition by going to Actions -> Import Data Sources.

On running the process it always runs the process based on the last uploaded file. If no file was uploaded, it uses the default file. A default file is created when the action is created for the very first time. After 48 hours, even the default file will expire and the process/import will no longer successfully finish. This is also the point where the Set Default File for administrator, everyone or just me comes into play. Each user can have their own default file definition

Hope this clarifies!

Regards,
Anirudh

Nitheesh

Thanks Anirudh for your patience in responding to the queries . Really appreciate the efforts .

Regards ,
Nitheesh

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