Viewing Incoming API CSV Files on Anaplan Server

john.roesser

Hi Anaplan Community!

My colleague and I are currently working on a new API connection between EDW and their Anaplan Data Hub. We are currently having difficulty loading all files through the connection. We have reviewed the queries and scripting for sending over the CSV files and cannot find any errors. We also are receiving consistent 204 messages and Anaplan processes are triggered in the model. However, the files are different when they arrive in the model than when pulled from the SQL query. Are the files possibly cut when arriving on the Anaplan server but before sent to the model? Is it possible to view these files and any possible error communications on the server before sent to the model?

vanreign

Hi John,

This does a good job to help troubleshoot including API calls for information you mention:

https://anaplanbulkapi20.docs.apiary.io/#/reference/import-actions

Anaplan's Official Guide is here:

https://help.anaplan.com/check-the-dump-file-for-imports-720b2e7c-593a-4f57-b677-22f4b1712924

Issue probably is not this but just walking through configuration areas that could be involved:

https://help.anaplan.com/split-your-file-into-chunks-e2a15065-32bb-47ce-9c34-87d28f4efeaa#:~:text=Chunks%20can%20be%20from%201%20to%2050%20megabytes%20in%20size. Integration solutions can upload chunks of sizes from 1MB to 50MB

The server processes the request successfully and sends a 204 No Content status code in response, which indicates that the request has been successfully processed, but there is no response body sent returned. The server does not send any content in the response body because there is no content to send. which is the expected response to a POST for tasks.

Also, under Actions\Import Data Source, there is some visibility into what is making it into Anaplan. The original file must have been set with a default file shared with Everyone or Admins Only. You can click Edit and view a portion of what has been uploaded. If it was set as default file of Private, you can select New Source and Upload New File with the same name and just column headers, Save. And the next time you run the API, look here after to see what made it in.

I hope some of this helps,

Cheers,

James

Vinz

@john.roesser A very easy way to view the entire file is to use a Tool like Postman, Paw or Insomnia to download the content of the file fot the fileId you're interested in.