Retrieve Link Table Records

This endpoint retrieves all link records within a specified link table. Specify the link table name to retrieve, and the response returns the field names and their corresponding field values of the link records. If a link record field name does not contain a value in the link table, field value returns null.

Note: The Responsys Advanced API is generally available for all Responsys customers.

Service URL:

/rest/api/v1.3/folders/{folderName}/linkTables/{linkTableName}

Required Path Parameters:

folderName – The folder name containing the link table to retrieve records.

linkTableName – The link table name that contains records to retrieve.

Request Method:

GET

Request Header:

Authorization=<AUTH_TOKEN>

Content-Type=application/json

Request Body - Required Properties:

Not applicable

Sample Request Body

Not applicable

Sample Response Body - Success

{
  "recordData": {
    "fieldNames": [
      "LINK_NAME",
      "LINK_URL",
      "LINK_CATEGORY",
      "EXTERNAL_TRACKING",
      "CREATED_DATE_",
      "MODIFIED_DATE_",
      "IOS_LINK_URL",
      "ANDROID_LINK_URL"
    ],
    "mapTemplateName": null,
    "records": [
      {
        "fieldValues": [
          "siteurl",
          "www.oracle.com",
          null,
          null,
          "2019-12-18 13:36:53.903857",
          "2019-12-18 13:36:53.903857",
          null,
          null
        ]
      },
      {
        "fieldValues": [
          "blogurl",
          "www.oracleblogs.com",
          null,
          null,
          "2019-12-18 13:36:53.903857",
          "2019-12-18 13:36:53.903857",
          null,
          null
        ]
      }
    ]
  },
  "links": [
    {
      "rel": "self",
      "href": "/rest/api/v1.3/folders/Folder_Name/linkTables/New_Link_Table",
      "method": "GET"
    },
    {
      "rel": "createLinkTable",
      "href": "/rest/api/v1.3/folders/Folder_Name/linkTables/New_Link_Table",
      "method": "POST"
    },
    {
      "rel": "deleteLinkTable",
      "href": "/rest/api/v1.3/folders/Folder_Name/linkTables/New_Link_Table",
      "method": "DELETE"
    },
    {
      "rel": "mergeLinkRecords",
      "href": "/rest/api/v1.3/folders/ Folder_Name/linkTables/New_Link_Table/members",
      "method": "POST"
    }
  ]
}