1. Data integration
  2. Anaplan API
  3. Integration API v2.0
  4. Use the transactional APIs
  5. 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 may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.