2. Data integration
  3. Anaplan API
  4. Integration API v2.0
  5. Use the transactional APIs
  6. Transform Grid CSV to Tabular Single Column format

Many integration tools rely on cell data exported in Tabular Single Column (TSC) CSV format.  The Anaplan API that reads cell data only supports exports in Grid CSV format.  You can transform Grid CSV format exports into TSC CSV format with these instructions.

To transform Grid CSV format exports to TSC CSV format:

  1. Retrieve the view metadata and grid view data.
  2. Map the items.
  3. Build the Tabular Single Column output.

If you are coding your own integration tool, we've prepared pseudocode to explain the transformation process.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.