How can I add dimension item ids/names to a module through a transactional API?

PaulWoodhead · 2023-03-02T18:04:17+00:00

There was an error rendering this rich post.

Hi I'm currently trying to use the write cell data transactional API to fill a module in Anaplan with required information. However I can only currently add to dimension ids/names already defined in my module.

For reference, in my current module Dimensions sequentially increase in number #1,#2,#3 etc.

I can add to these but when the top value is reached (#690 in this case) I wouldnt be able to add information to a "#691st " line.

For context I'm trying to bring in information automatically on a scheduled basis and so dont want to rely on adding lines manually to my module and then writing to them in an API as that wont be practical

Accepted answers

All comments

AlejandroGomez

I do not think you can change the dimensionality of a module through the transactional API.

It sounds as if new List items were needed. For instance, if your current module has 2 dimensions of 5 and 3 items respectively, each cell will be uniquely identified with a code from #1 to #15.

#15 in my example seems to be the equivalent to your #690. If you want to add data to the cell (or intersection) #691, first you need to create it by creating a new item in the lists (a new column or cell)

in your case, #691 would be #16 in my example. Whether or not you can add more items to a list through the transactional API, i ignore it. This is my best attempt to explain the behaviour described in your question.

I hope it helps

Alex

PaulWoodhead

Hi Alex thankyou for your response yes the list item add action has been helpful. I have used this API "{anaplanurl}/2/0/models/{modelID}/list/{listID}/items?action=add to add the item I needed.

Do you know if it is possible to add a list item and write the cell information to it in one API call? effectively combining/expanding the first call with the the write cell data API:

{anaplanurl}/2/0/models/{Model}/modules/102000000100/data

AlejandroGomez

Hi,

I would say yes, you shoul be able to do so, since the Transactional API allows you to do both.

But i am sorry to say that i have never tried it myself and I cannot see any specific example on how to do it in the API guide.

All I can do right now is try to summon the big guns here, my friend and mentor in data integration @ABerenguela. Let's see if we are lucky, he is a busy man.

Cheers,

Alex

PaulWoodhead

Hi,

thankyou Alex, I will wait for his reply... If the above is possible, it would be good to know also if such a call can be batched so that multiple lines of information can be written to a module in one call. I.e. would one API call be capable of creating list items and writing the respective cell data for say 100 lines of module data.

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
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…