Anaplan & MS Access Transactional API using Python

Hi,

I'm trying to update the data in Anaplan module line items directly from MS Access by converting into json format using Python transactional APIs.

I'm keep getting the "Status code 400" , "Message - Post body is not a valid json". I have tried by printing the json format before sending the data into Anaplan and format is true as i checked the format in jsonlint.com and i tried with different possibilities of error rectification but still throwing the same error again and again.

@StevenBeerthuizen @ryan_kohn @eschau @kevin.cho anybody can help me fix this issue?

Sample Ms access data

Accepted answers

All comments

kevin.cho

Copy out the payload that you're trying to write here, so we can take a look.

JakkalaDevivaraprasad

@kevin.cho

Payload.png

Attached the snapshot the payload and also attached the sample code in the above post

kevin.cho

Do you mind copying what the code is actually generating though? (Sanitised)

Just comparing it with what I've configured in Postman, I don't send it as

{"updates": [….]}

but rather just

[

…

]

where … is what you have defined here

"lineItemId": str(line_item_id),
                        "dimensions": dimensions,
                        "value": value

JakkalaDevivaraprasad

@kevin.cho

{
"updates": [
{
"lineItemId": "XXXXXXXXX",
"dimensions": [
{
"dimensionId": "XXXXXXXX",
"itemId": "XXXXXXXXX"
}
],
"value": "France"
},
{
"lineItemId": "XXXXXXXXXX",
"dimensions": [
{
"dimensionId": "XXXXXXXXX",
"itemId": "XXXXXXXXXXXXX"
}
],
"value": "Sales"
}
]
}
the above is the output of the code snippet

kevin.cho

Thanks

Change it to json.dumps(updates…) rather than json.dumps(payload)

Should just be a list of CellWrite objects, you don't need them to be captured in the "updates" object.

i.e.

[
    {
    "lineItemId": "XXXXXXXXX",
    "dimensions": [
    {
    "dimensionId": "XXXXXXXX",
    "itemId": "XXXXXXXXX"
    }
    ],
    "value": "France"
    },
    {
    "lineItemId": "XXXXXXXXXX",
    "dimensions": [
    {
    "dimensionId": "XXXXXXXXX",
    "itemId": "XXXXXXXXXXXXX"
    }
    ],
    "value": "Sales"
    }
]

Based on:

https://anaplan.docs.apiary.io/#WriteCellDataByCoordinateorName

"Ensure the request body is an array of CellWrite objects. Each object is for an updated individual cell and its full set of dimensions."

JakkalaDevivaraprasad

@kevin.cho

I have tried changing the into json.dumps(updates) and still it throws the same error. And also i have validated the json format and it is correct.

Not understanding why it gives the error

pyrypeura

Hi,

In your python code as you are using json option of request library you will need to post the list formatted data there not the string formatted json_dump. From your format Anaplan payload you could simply return your updates list and send that as json parameter of your request.post.

kevin.cho

+1 to @pyrypeura's solution

if you want to pass through the string format from json.dumps(…), use parameter "data" instead of "json"

You'll still need to get rid of the "updates" object however.

Quick Links

Can you help?

Unanswered questions

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