Trying to get .xlsx from Anaplan Connect but comes out as csv

alismith
alismith
in Integrations and extensibility

I have an export that I am trying to run through anaplan connect 4.2.1 however it is causing some issue

When I run the export direct in anaplan, it comes out directly as an .xlsx file, but in anaplan connect its format is .xlsx but excel won't open it, and if I rename the extension to .csv, it opens correctly.

So it seems anaplan connect is saving the csv file, with a .xlsx extension which is causing some issues for us.

Any suggestions

Tagged:

Answers

  • devrathahuja
    devrathahuja

    Hello,
    Have you checked if the original export action in Anaplan has the setting to save it as .xlsx and not CSV?

  • alismith
    alismith

    Issue seems to be in the API. If we upload to and anaplan and export in the same script the export comes out in the same format as the import.

    If it's ran as two scripts both are fine.

Categories