Unexpected API(POST) Error

I want to import view data in the Azure Synapse Analytics pipeline, but I am getting errors in creating the request.
The error statement is this, is the Body wrong?

・Error message

{ "errorCode": "2108", "message": "{\n \"status\" : {\n \"code\" : 400,\n \"message\" : \"Missing or invalid body\"\n },\n \"path\" : \"/2/0/workspaces/{workspaceID}/models/{modelID}/views/{viewID}/readRequests/\",\n \"timestamp\" : \"2022-10-12T10:34:12.220164Z\"\n}", "failureType": "UserError", "target": "initiate_request", "details": [] }

・URL

https://api.anaplan.com/2/0/workspaces/{workspaceID}/models/{modelID}/views/{viewID}/readRequests/

・body

curl --location --request POST 'https://api.anaplan.com/2/0/workspaces/{workspaceID}/models/{modelID}/views/{viewID}/readRequests/' \
--data-raw '{
"exportType" : "TABULAR_MULTI_COLUMN"
}'

・Header

Authorization :

concat('AnaplanAuthToken ',activity('get_access_token').output.tokenInfo.tokenValue)

・Accept : application/json

*workspaceID, modelID, and viewID are hidden for security reasons. (The actual IDs are entered when an API call is made.)

Does anyone know how to solve this?
Any help would be appreciated.

Thank you.

Accepted answers

All comments

StevenBeerthuizen

Did you also validate your API call in Postman? And what does it give you there?

KR,

Steven

StevenBeerthuizen

My first guess would be that in your body you shouldn't put the whole curl request but only for example:

{
"exportType": "TABULAR_MULTI_COLUMN"
}

Kr,

Steven

CuteeeeRabbit

Thank you for your reply.

I tried it and it worked well.

I really appreciate your help.

I have one more question.

If I want to extract all data from a view, should I use

{"exportType" : "GRID_ALL_PAGES"} ?

I didn't understand much from the reference.

I look forward to your reply.

StevenBeerthuizen

It seems to me that this large volume retrieve takes all data already if you use TABULAR_SINGLE_COLUMN or TABULAR_MULTIPLE_COLUMN without filtering or order.

If you want to export data that is filtered and/or ordered already before export you can use GRID_ALL_PAGES

That is my intepretation of the information anyway, i haven't used it myself.

Kind regards,

Steven

CuteeeeRabbit

I use TABULAR_MULTIPLE_COLUMN, and it worked.

Thank you for your help!

StevenBeerthuizen

Glad i could help. If you have no further question, maybe you could mark this topic as solved.
Kind regards,
Steven

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…