Fetching export ID directly while Integrating Anaplan with MuleSoft

Hi All,

I was trying to integrate Anaplan with MuleSoft and followed all the steps provided as per the Integration guideline.

but we have an issue while trying to find the export ID(to be provided in mule soft) for a particular export action created in the Model.

Instead of querying the mentioned model id, the API is querying the entire workspace for all the available models which is occupying all the available cores of server and affecting the performance.

Below is the url format executed.

https://api.anaplan.com/1/3/workspaces/workspaceID/models/ModelID/exports

Thanks & Regards,

Madhu

Accepted answers

All comments

jesse_wilson

Hi @MadhabikaM

Unfortunately, action IDs (imports, exports, etc) aren't visible in the Anaplan model. You could use Mulesoft to send a RESTful request to fetch the IDs you need, but I would recommend using Postman for this. Whenever I'm working with Mulesoft, it's the tool I use to fetch IDs - it's far quicker to simply scroll through the response this way than in Mulesoft, or to design a workflow to pull the IDs, parse through to find the action name and match to its ID, then pass to the Anaplan object.

In Postman, just provide your Anaplan credentials in the Authorization tab, and send a GET request to the URL you mentioned (https://api.anaplan.com/1/3/workspaces/workspaceID/models/ModelID/exports). This will return a list of the exports in the model, find the name of the export you want to trigger and copy the corresponding ID into Mulesoft.

Regards

MadhabikaM

Hi @Jesse

Thank for your response on this, I missed to mention here but we did used Postman to get the export ID's using same url format which inreturn gives all the export ID's in that Model but it also was overloading some of our cores because of heavy model usage.
On investigating we found that the query was hitting all the models about 277 in same workspace leading to this issue.
We are not sure why it executes on entire workspace though we specify only single model ID.
have you faced such scenario before or we are missing something here, Please do let me know.

Thanks & Regards,
Madhu

jesse_wilson

Could you share a screenshot of the settings of the Anaplan object in Mulesoft?

How did you determine the request was hitting all your models? There's no functional way that Mulesoft should be hitting all your models with the same request, and even so the odds of all these being valid and triggering exports seems slim.

MadhabikaM

Hi @jesse_wilson ,

Thanks again for your response, I have attached a screenshot of Anaplan object in Mulesoft.

It has been reported by our Infra Team that this particular action executed from my id has occupied the core space and on investigating they found that this particular url is executing on all the models in that workspace.

We are really unaware of what and how this is happening, do we need to check on any specific log file.

I can ask them with my infra team.

Thanks & Regards,

Madhu

AnaMule_connection_43760.png

jesse_wilson

Hi,

I see you're using the new version of the Anaplan connector for Mulesoft. All of your configuration details look correct, so it's possible you've encountered a bug in the connector.

In this case, I would recommend raising a support case with our team (support@anaplan.com). Share with them the execution log, and the results your team has found. They can check our backend logs to see what's going on and raise a bug with our engineering team if they determine it's needed.

Thanks!

MadhabikaM

Hi @jesse_wilson,

Thanks, yes have raised a support case regarding the same, will update here If we find the resolution for this.

Regards,

Madhabika

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385