You can import up to 5 CSV files that will be converted to reference sets in your Connect subscription. If the default limit is insufficient, it is possible to extend it up to 25 on request.

File requirements

• Maximum size - 5 GB
• Format - CSV, comma-separated
• Encoding - UTF-8
• Phone numbers. If a file contains phone numbers, they must be formatted according to the ISO E.164 standard: +[country code][area code][phone number]. No spaces, dashes or special characters are allowed.
• Dates. If a file contains dates, they must in the UTC format (YYYY-MM-DDTHH:mm:ssZ). 2024-11-01T16:04:38Z
• The header row is optional.

Initial setup

To start importing reference sets, you need to establish access to our SFTP server.

1. Run the following command in your terminal emulator.

ssh-keygen -t ed25519 -C "Acoustic.com - Connect key" -f key

2. Find two files in your user folder: a private key (key) and a public key (key.pub).
3. Log in to your Acoustic Connect account, click on your user icon in the upper-right corner and then select Edit profile.

4. Scroll down to the SSH Key section and upload your key.pub file there.

5. Click on the Apps icon in the upper-right corner and then select the hamburger icon next to your subscription. Click Copy subscription ID. Keep the ID handy for the upcoming steps.

6. Create a new connection in an FTP client such as FileZilla. The settings are described below.

7. Navigate to the directory allocated for your subscription. For example, if your subscription ID is 000000000X, then the directory will be named sub_000000000X.
8. (optional) Create a sub-directory for reference sets.
9. Upload your files.

📘

Note

When the import job is completed, the files will be deleted from the SFTP server.

Settings for the SFTP connection

Host

Use a host associated with your Connect domain

Other settings

• Protocol: SFTP – SSH File Transfer Protocol
• Port: 22
• Logon type: key file
• Key file: specify a path to the private key file on your hard drive
• User: the username that you sign in to Acoustic Connect with.

Example

Let's say you want to import order history to Connect and later link each order to a contact in your audience.

Mutation structure

Once the file has been uploaded to the server, you can run a mutation to import the file to Connect.

mutation ($importInput: ImportInput!) {
  createImportJob(importInput: $importInput) {
    id
  }
}

{
  "data": {
    "createImportJob": {
      "id": "1fbe6f9e-572e-4849-1111-00000x00000x"
    }
  }
}

The mutation requires a JSON object.

{
  "importInput": {
    "dataSetName": "Orders",
    "dataSetType": "REFERENCE_SET",
    "attributes": {
      "create": [
        {
          "name": "Order ID",
          "type": "TEXT",
          "identifyAs": {
            "key": true
          }
        },
        {
          "name": "Client ID",
          "type": "TEXT"
        },
        {
          "name": "Amount",
          "type": "NUMBER",
          "decimalPrecision": 2
        },
        {
          "name": "Date",
          "type": "DATE"
        },
        {
          "name": "First-time purchase",
          "type": "BOOLEAN"
        },
                {
          "name": "Discount coupon",
          "type": "TEXT"
        }
      ]
    },
    "jobName": "Add orders",
    "importType": "CREATE",
    "fileLocation": {
      "type": "SFTP",
      "filename": "orders.csv",
      "folder": "reference-sets"
    },
    "skipFirstRow": true,
    "mappings": [
      {
        "columnIndex": 1,
        "attributeName": "Order ID"
      },
            {
        "columnIndex": 2,
        "attributeName": "Client ID"
      },
            {
        "columnIndex": 3,
        "attributeName": "Amount"
      },
            {
        "columnIndex": 4,
        "attributeName": "Date"
      },
            {
        "columnIndex": 5,
        "attributeName": "First-time purchase"
      },
                  {
        "columnIndex": 6,
        "attributeName": "Discount coupon"
      }
    ]
}

Arguments

Arguments required by the createImportJob mutation:

Parameters supported by the importInput object

Fields supported by objects within the attributes field:

Fields supported by objects within the mappings field:

Fields

Fields returned by the createImportJob mutation:

Further steps

Now you can connect the reference set to the audience or to another reference set. For instructions, see Connect reference sets.