Rest API 403 Forbidden Error while Update module cell data

MayankP

Hi All,

Using below link I am trying update module cell data using Transactional APIs using Postman.

https://anaplanbulkapi20.docs.apiary.io/#WriteCellDataByCoordinateModule

But I am getting 403 Forbidden error. I am able to use all other GET request successfully.

Please find below screen shot:

I can manually login to Anaplan and update the cells manually but unable to do the same using APIs.

I have full authorizations as shown below:

I am not sure what I am missing. Please help.

Regards

Mayank

Accepted answers

All comments

KirillKuznetsov

It might be obvious, but still.
Did you replace orange variables in Header for token and URL (WS & Model IDs)?

MayankP

Hi Kirill,

Yes, I am using environment variable feature of postman for ease of use and chaining the requests.

Orange variable are environment variables and their values are maintained. I have tried passing the values directly without variables as well but same result.

Regards

Mayank

yrignac

Hello,

Your input module has only 2 lists ? Are you sure about dimension ID ?

Member id selected is only base member ?

Line item selected is an input line item (without any formula) ?

Did you try to upload to an other module or line item of the module ?

Regards,

Yohan

kevin.cho

The Transactional APIs require workspace admin rights, so I'd check again if you have Workspace Admin privileges in the workspace that the model you are trying to update. I know your screenshot showed you have Workspace Admin, but it could potentially be across a different Workspace.

MayankP

Hi Yohan,

I checked all the IDs and seems to be correct. I got the IDs from other GET requests as mentioned in below link

https://anaplanbulkapi20.docs.apiary.io/#ModuleAndViewData

I am trying to update one cell value in the module which has 2 dimensions Time and Product

Below is the dimension IDs I get

Not sure if this is a right way but in order to double-check IDs I made a change manually in exact same field which I am trying to update in Anaplan and tried to analyze request body in inspect, seems values I am passing are correct.

Values in request body from inspect and values in Postman are mapped with color coding for your reference:

I am not an expert in APIs, hope I am looking at right place.

Appreciate your help.

Regards

Mayank

MayankP

Hi Kevin,

Yes I have Workspace admin rights for all the Workspaces. (We have only 2 Workspace).

Regards

Mayank

kevin.cho

Okay thanks for checking - on a random thought are you using a bot account/integration account to authenticate, and not your actual profile that you log in via the front end? I use a bot account that we have a certificate configured to authenticate, rather than my own personal credentials.

MayankP

Hi Kevin,

I am using Basic Authentication using personal credential to get the authentication token, which is working fine in other GET requests. We are still in implementation phase and so far we have not created an integration account.

Is there any limitation in using personal account?

Regards

Mayank

kevin.cho

Not that I'm aware of. 403 errors are normally not as a result of the request being malformed, and neither to do with your credentials being invalid; rather, it could be something to do with security on the model side... I just checked model role (which doesn't seem to be the issue, if the model role isn't set correctly it returns a 404), malformed requests (i.e. incorrectly formatted body) which returns a 400, not really sure what else to check unfortunately 😞

I'll try the Workspace Admin setting tomorrow when my colleague is online, unfortunately I can't switch myself off Workspace Admin.

KirillKuznetsov

@MayankPtry with disabled SSO if you didn't yet.

MayankP

We have not configured single Sign on.

MayankP

Thanks and appreciate your help Kevin...

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…