This article explains how to generate the Import configurations ID you need to build a data connector between an external data source, such as Looker or Workday, and Pigment.  

Generate an import configurations ID

Generating an import configurations ID is a 3-step process: 

1. Get a CSV extract sample from the external data source.
2. Run an import into Pigment and save your configurations.
3. Copy the import configuration ID in Pigment.

Get a CSV extract sample from the external data source

To transfer data into Pigment, start by exporting the data in CSV format. Ensure that the data structure is identical to the one required for the integration, including matching headers and the correct CSV delimiter. After preparing the file, do an initial import it into Pigment. This test import defines how Pigment recognizes the file format and establishes the appropriate data mappings.

Run an import with the sample file 

1. Open the List or Metric where you want to import the data.
2. Click the menu (...) and select Import data.
3. Upload the CSV file, and select the required fields for the import. 
   For more information, see How to Import Data Manually into Lists. 
4. In the Import Summary screen, click Save to save the import configuration. 
5. Enter a meaningful name and description for your import configuration so you can easily locate it later. 

Copy the import configuration ID

1. Go to your Block and open Settings.
2. Open Import configurations.
3. Click on the menu (...) and click Copy ID.
   If there is an error with the import configuration, you will not be able to copy the ID. 
4. Paste this ID into the configuration settings of your data connector.
   
   For more information, see How to Trigger an Import with APIs.