Download and upload metadata

The metadata from the Integrations catalog downloads in CSV file format. Download options include:

  • Entire Table—includes all SnapLogic metadata and any custom data that has been added.
  • Customer Data Only—only supplemental data that has been added.
  • Template—the first row includes the uid and any custom columns. The remaining rows contain the uid value for all integrations.

Upload supplemental metadata in the same CSV format. Each integration has a unique id, uid, consisting of the project path and task name. To add supplemental metadata, define custom columns and correlate the supplemental metadata with the integration unique ID. Supplemental data can be text or numeric. You don't need to enclose it in quotes. Refer to Reserved column names for a list of names to avoid for custom columns.

Important: You can only edit and import custom fields and custom values. Any attempt to import values for any of the fields populated by Monitor will fail.

On upload of a CSV file:

  • Rows in the input file overwrite any existing supplemental data for that integration ID.
  • If more than one row has the same ID, values from the last matching row load into the catalog.
  • Incomplete rows, those with values for only some custom columns, overwrite existing custom values.

To add supplemental metadata values for a few integrations, you can create your own CSV file and upload it. To add values for many integrations, it's easier to download a template, because templates include the integration ids.

Create a CSV file

The following steps describe how to add the first custom column and supplemental metadata. If custom columns already exist and you add more, be sure to insert the appropriate number of commas so that the values appear in the correct column.

To add the first custom column:

  1. Create a CSV file with one row that specifies the uid column and your custom column name. For example to create a my-custom column:
    uid,my-custom
  2. Find the uid of the integrations that you want to add custom metadata. For each integration:
    1. Click the integration name to open the details panel:
      Integration details panel

    2. Copy the Project Path and paste it in the next row of the CSV file.
    3. Add a slash (/)after the project path.
    4. Copy the task Name and append it to the project path. For example:
      /ADM-DEV/projects/shared/SalesForce_To_SnowFlake_Pipeline_2 Triggered Task
    5. Enclose the uid in quotes.
    6. Add a comma and the custom value. For example:
      "/ADM-DEV/projects/shared/SalesForce_To_SnowFlake_Pipeline_2 Triggered Task", 100
  3. Save the file.
  4. On the Integrations catalog page, click Download & upload metadata.
  5. Click the Upload CSV card.
  6. Select the CSV file you created and upload it.
  7. A message confirms the number of successful updates and errors.
  8. Refresh the Integrations catalog screen to view the custom value.

Use a template to add supplemental metadata

Follow these steps:

  1. On the Integrations catalog page, click Download & upload metadata.
  2. Click the Download Template card.
  3. Open the downloaded CSV file.
  4. On the first row, add your custom column name.
  5. In the integration rows, add the supplemental values.
  6. Save the file.
  7. Click the Upload CSV card and upload it.
  8. A message confirms the number of successful updates and errors.
  9. Refresh the Integrations catalog screen to view the custom value.