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.
⚠️ Important
Only users with the Import Data permission in the application can access or generate import configuration IDs.
Generate an import configurations ID
Generating an import configurations ID is a three-step process:
Get a CSV extract sample from the external data source.
Run an import into Pigment and save your configurations.
Copy the import configuration ID in Pigment.
Get a CSV extract sample from the external data source
To transfer data into Pigment, first export your data into a CSV format. Ensure that the data structure matches the format required for import, including consistent headers and the same CSV delimiter. You will need to manually import this data into Pigment once in order to define how Pigment should read the file and the appropriate mappings.
Run an import with the sample file
Open the List or Metric where you want to import the data.
Click the three dots menu and select Import data.
Upload the CSV file, and select the required fields for the import.
For more information, see How to Import Data Manually into Lists.In the Import Summary screen, click Save to save the import configuration.
Enter a meaningful name and description for your import configuration so you can easily locate it later.
Copy the import configuration ID
Go to your Block and open Settings.
Open Import configurations.
Click the three dots menu and Copy ID.
If there is an error with the import configuration, you will not be able to copy the ID.Paste this ID into the configuration settings of your data connector.