REST API for Oracle Integration

Create a Lookup

post

/ic/api/integration/v1/lookups

Creates a lookup. The request body must contain:

name: defines the name of the lookup. For example:
```
"name":"myLookup"
```
columns: defines the domains or adapters to map. The request body can contain two or more columns. For example:
```
"columns":["rightnow","soap"]
```
rowData: specifies the mappings to each adapter or domain. For example:
```
"rows":[{"rowData":["RN1","SOAP1"]},{"rowData":["RN2","SOAP2"]}]
```

Request

Supported Media Types

application/json; charset=utf-8

Lookup resource

Root Schema : lookup

Type: object

Show Source

adapters(optional): array adapters
columns(optional): array columns
created(optional): string(date-time)
createdBy(optional): string
description(optional): string
id(optional): string
keywords(optional): string
lastUpdated(optional): string(date-time)
lastUpdatedBy(optional): string
links(optional): array links
lockedBy(optional): string
lockedDate(optional): string(date-time)
lockedDVMFlag(optional): boolean

Default Value: false
lockedFlag(optional): boolean

Default Value: false
name(optional): string
resourcePath(optional): string
rowCount(optional): integer(int32)
rows(optional): array rows
rowsAsArray(optional): array rowsAsArray
status(optional): string
usage(optional): integer(int32)
usageActive(optional): integer(int32)

{
    "type":"object",
    "properties":{
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/Link"
            }
        },
        "id":{
            "type":"string"
        },
        "name":{
            "type":"string"
        },
        "description":{
            "type":"string"
        },
        "rowCount":{
            "type":"integer",
            "format":"int32"
        },
        "status":{
            "type":"string"
        },
        "lastUpdatedBy":{
            "type":"string"
        },
        "lastUpdated":{
            "type":"string",
            "format":"date-time"
        },
        "lockedBy":{
            "type":"string"
        },
        "lockedDate":{
            "type":"string",
            "format":"date-time"
        },
        "created":{
            "type":"string",
            "format":"date-time"
        },
        "createdBy":{
            "type":"string"
        },
        "lockedDVMFlag":{
            "type":"boolean",
            "default":false
        },
        "lockedFlag":{
            "type":"boolean",
            "default":false
        },
        "columns":{
            "type":"array",
            "items":{
                "type":"string"
            }
        },
        "adapters":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/AdapterTypeRs"
            }
        },
        "usage":{
            "type":"integer",
            "format":"int32"
        },
        "usageActive":{
            "type":"integer",
            "format":"int32"
        },
        "resourcePath":{
            "type":"string"
        },
        "rows":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/SuiteLookupRowData"
            }
        },
        "keywords":{
            "type":"string"
        },
        "rowsAsArray":{
            "type":"array",
            "items":{
                "type":"array",
                "items":{
                    "type":"string"
                }
            }
        }
    },
    "xml":{
        "name":"lookup"
    }
}

Nested Schema : adapters

Type: array

Show Source

Array of: object adapter

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/AdapterTypeRs"
    }
}

Nested Schema : columns

Type: array

Show Source

Array of: string

{
    "type":"array",
    "items":{
        "type":"string"
    }
}

Nested Schema : links

Type: array

Show Source

Array of: object Link

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/Link"
    }
}

Nested Schema : rows

Type: array

Show Source

Array of: object SuiteLookupRowData

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/SuiteLookupRowData"
    }
}

Nested Schema : rowsAsArray

Type: array

Show Source

Array of: array items

{
    "type":"array",
    "items":{
        "type":"array",
        "items":{
            "type":"string"
        }
    }
}

Nested Schema : adapter

Type: object

Show Source

customSecurityPolicyDescription(optional): string
defaultSecurityPolicies(optional): string
description(optional): string
displayName(optional): string
features(optional): string
genericAuthSupport(optional): array genericAuthSupport
icons(optional): object adaptericons
id(optional): string
infoMessage(optional): string
integrationRole(optional): string

Allowed Values: [ "SOURCE", "TARGET", "SOURCE_AND_TARGET" ]
links(optional): array links
name(optional): string
oauth3LeggedSupport(optional): array oauth3LeggedSupport
otherVersions(optional): string
supportedSecurityPolicies(optional): string
testKey(optional): string
testMessage(optional): string
type(optional): string
validateAndTestKey(optional): string
validateAndTestMessage(optional): string
vendorInfo(optional): object VendorInfo
version(optional): string
wsdlvalidation(optional): boolean

Default Value: false

{
    "type":"object",
    "properties":{
        "links":{
            "type":"array",
            "items":{
                "$ref":"#/definitions/SuiteLink"
            }
        },
        "id":{
            "type":"string"
        },
        "name":{
            "type":"string"
        },
        "displayName":{
            "type":"string"
        },
        "type":{
            "type":"string"
        },
        "supportedSecurityPolicies":{
            "type":"string"
        },
        "defaultSecurityPolicies":{
            "type":"string"
        },
        "features":{
            "type":"string"
        },
        "version":{
            "type":"string"
        },
        "description":{
            "type":"string"
        },
        "integrationRole":{
            "type":"string",
            "enum":[
                "SOURCE",
                "TARGET",
                "SOURCE_AND_TARGET"
            ]
        },
        "vendorInfo":{
            "$ref":"#/definitions/VendorInfo"
        },
        "icons":{
            "$ref":"#/definitions/AdapterIconsRs"
        },
        "wsdlvalidation":{
            "type":"boolean",
            "default":false
        },
        "testKey":{
            "type":"string"
        },
        "validateAndTestKey":{
            "type":"string"
        },
        "testMessage":{
            "type":"string"
        },
        "validateAndTestMessage":{
            "type":"string"
        },
        "infoMessage":{
            "type":"string"
        },
        "genericAuthSupport":{
            "type":"array",
            "items":{
                "type":"string",
                "enum":[
                    "BASIC_AUTH",
                    "USERNAME_PASSWORD_TOKEN",
                    "USERNAME_PASSWORD_IGNORE_TIMESTAMP",
                    "OAUTH_CLIENT_CREDENTIALS",
                    "OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
                    "SAML",
                    "OAUTH",
                    "CUSTOM",
                    "TEMPLATE_BASED",
                    "TOKEN_BASED",
                    "NONE",
                    "PLUGIN_AUTHORIZATION_CODE_CREDENTIALS",
                    "TIMEOUT_AUTHORIZATION_CODE_CREDENTIALS",
                    "PLUGIN_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
                    "PLUGIN_CLIENT_CREDENTIALS",
                    "MIN_PLUGIN_AUTHORIZATION_CODE_CREDENTIALS",
                    "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
                    "OAUTH20_AUTHORIZATION_CODE_CREDENTIALS",
                    "CUSTOM_THREE_LEGGED",
                    "CUSTOM_TWO_LEGGED",
                    "CUSTOM_SINGLE_TOKEN",
                    "OAUTH_ONE_TOKEN_BASED",
                    "NETSUITE_TOKEN_BASED",
                    "PAAS_INTEGRATION_USING_OWSM_OAUTH20",
                    "FTP_PUBLIC_KEY_AUTHENTICATION",
                    "FTP_MULTI_LEVEL_AUTHENTICATION",
                    "OAUTH_INBOUND",
                    "AWS_SIGNATURE_VERSION4",
                    "OAUTH2_PRECONFIGURED_CLINET_ID_SECRET",
                    "OAUTH2_CCS_ROP_PRECONFIGURED",
                    "OAUTH2_CCS_ROP",
                    "OAUTH2",
                    "CCS_BASIC_AUTH",
                    "CCS_API_KEY",
                    "JDBC_OVER_SSL",
                    "JDBC_BASIC_AUTH",
                    "FA_OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
                    "FA_OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
                    "ORACLE_WALLET",
                    "OCI_SIGNATURE_VERSION1",
                    "SASLPLAIN",
                    "SASLPLAIN_OVER_SSL",
                    "SASLPLAIN_OVER_SSL_OSS",
                    "TLS",
                    "MUTUAL_TLS",
                    "UIPATH_CLOUD",
                    "AS2_ADVANCE_SEC_PROPS",
                    "AS2_BASIC_SEC_PROPS"
                ]
            }
        },
        "customSecurityPolicyDescription":{
            "type":"string"
        },
        "otherVersions":{
            "type":"string"
        },
        "oauth3LeggedSupport":{
            "type":"array",
            "items":{
                "type":"string",
                "enum":[
                    "BASIC_AUTH",
                    "USERNAME_PASSWORD_TOKEN",
                    "USERNAME_PASSWORD_IGNORE_TIMESTAMP",
                    "OAUTH_CLIENT_CREDENTIALS",
                    "OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
                    "SAML",
                    "OAUTH",
                    "CUSTOM",
                    "TEMPLATE_BASED",
                    "TOKEN_BASED",
                    "NONE",
                    "PLUGIN_AUTHORIZATION_CODE_CREDENTIALS",
                    "TIMEOUT_AUTHORIZATION_CODE_CREDENTIALS",
                    "PLUGIN_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
                    "PLUGIN_CLIENT_CREDENTIALS",
                    "MIN_PLUGIN_AUTHORIZATION_CODE_CREDENTIALS",
                    "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
                    "OAUTH20_AUTHORIZATION_CODE_CREDENTIALS",
                    "CUSTOM_THREE_LEGGED",
                    "CUSTOM_TWO_LEGGED",
                    "CUSTOM_SINGLE_TOKEN",
                    "OAUTH_ONE_TOKEN_BASED",
                    "NETSUITE_TOKEN_BASED",
                    "PAAS_INTEGRATION_USING_OWSM_OAUTH20",
                    "FTP_PUBLIC_KEY_AUTHENTICATION",
                    "FTP_MULTI_LEVEL_AUTHENTICATION",
                    "OAUTH_INBOUND",
                    "AWS_SIGNATURE_VERSION4",
                    "OAUTH2_PRECONFIGURED_CLINET_ID_SECRET",
                    "OAUTH2_CCS_ROP_PRECONFIGURED",
                    "OAUTH2_CCS_ROP",
                    "OAUTH2",
                    "CCS_BASIC_AUTH",
                    "CCS_API_KEY",
                    "JDBC_OVER_SSL",
                    "JDBC_BASIC_AUTH",
                    "FA_OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
                    "FA_OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
                    "ORACLE_WALLET",
                    "OCI_SIGNATURE_VERSION1",
                    "SASLPLAIN",
                    "SASLPLAIN_OVER_SSL",
                    "SASLPLAIN_OVER_SSL_OSS",
                    "TLS",
                    "MUTUAL_TLS",
                    "UIPATH_CLOUD",
                    "AS2_ADVANCE_SEC_PROPS",
                    "AS2_BASIC_SEC_PROPS"
                ]
            }
        }
    },
    "xml":{
        "name":"adapter"
    }
}

Nested Schema : genericAuthSupport

Type: array

Show Source

Array of: string

Allowed Values: [ "BASIC_AUTH", "USERNAME_PASSWORD_TOKEN", "USERNAME_PASSWORD_IGNORE_TIMESTAMP", "OAUTH_CLIENT_CREDENTIALS", "OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS", "SAML", "OAUTH", "CUSTOM", "TEMPLATE_BASED", "TOKEN_BASED", "NONE", "PLUGIN_AUTHORIZATION_CODE_CREDENTIALS", "TIMEOUT_AUTHORIZATION_CODE_CREDENTIALS", "PLUGIN_RESOURCE_OWNER_PASSWORD_CREDENTIALS", "PLUGIN_CLIENT_CREDENTIALS", "MIN_PLUGIN_AUTHORIZATION_CODE_CREDENTIALS", "OAUTH_AUTHORIZATION_CODE_CREDENTIALS", "OAUTH20_AUTHORIZATION_CODE_CREDENTIALS", "CUSTOM_THREE_LEGGED", "CUSTOM_TWO_LEGGED", "CUSTOM_SINGLE_TOKEN", "OAUTH_ONE_TOKEN_BASED", "NETSUITE_TOKEN_BASED", "PAAS_INTEGRATION_USING_OWSM_OAUTH20", "FTP_PUBLIC_KEY_AUTHENTICATION", "FTP_MULTI_LEVEL_AUTHENTICATION", "OAUTH_INBOUND", "AWS_SIGNATURE_VERSION4", "OAUTH2_PRECONFIGURED_CLINET_ID_SECRET", "OAUTH2_CCS_ROP_PRECONFIGURED", "OAUTH2_CCS_ROP", "OAUTH2", "CCS_BASIC_AUTH", "CCS_API_KEY", "JDBC_OVER_SSL", "JDBC_BASIC_AUTH", "FA_OAUTH_AUTHORIZATION_CODE_CREDENTIALS", "FA_OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS", "ORACLE_WALLET", "OCI_SIGNATURE_VERSION1", "SASLPLAIN", "SASLPLAIN_OVER_SSL", "SASLPLAIN_OVER_SSL_OSS", "TLS", "MUTUAL_TLS", "UIPATH_CLOUD", "AS2_ADVANCE_SEC_PROPS", "AS2_BASIC_SEC_PROPS" ]

{
    "type":"array",
    "items":{
        "type":"string",
        "enum":[
            "BASIC_AUTH",
            "USERNAME_PASSWORD_TOKEN",
            "USERNAME_PASSWORD_IGNORE_TIMESTAMP",
            "OAUTH_CLIENT_CREDENTIALS",
            "OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
            "SAML",
            "OAUTH",
            "CUSTOM",
            "TEMPLATE_BASED",
            "TOKEN_BASED",
            "NONE",
            "PLUGIN_AUTHORIZATION_CODE_CREDENTIALS",
            "TIMEOUT_AUTHORIZATION_CODE_CREDENTIALS",
            "PLUGIN_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
            "PLUGIN_CLIENT_CREDENTIALS",
            "MIN_PLUGIN_AUTHORIZATION_CODE_CREDENTIALS",
            "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
            "OAUTH20_AUTHORIZATION_CODE_CREDENTIALS",
            "CUSTOM_THREE_LEGGED",
            "CUSTOM_TWO_LEGGED",
            "CUSTOM_SINGLE_TOKEN",
            "OAUTH_ONE_TOKEN_BASED",
            "NETSUITE_TOKEN_BASED",
            "PAAS_INTEGRATION_USING_OWSM_OAUTH20",
            "FTP_PUBLIC_KEY_AUTHENTICATION",
            "FTP_MULTI_LEVEL_AUTHENTICATION",
            "OAUTH_INBOUND",
            "AWS_SIGNATURE_VERSION4",
            "OAUTH2_PRECONFIGURED_CLINET_ID_SECRET",
            "OAUTH2_CCS_ROP_PRECONFIGURED",
            "OAUTH2_CCS_ROP",
            "OAUTH2",
            "CCS_BASIC_AUTH",
            "CCS_API_KEY",
            "JDBC_OVER_SSL",
            "JDBC_BASIC_AUTH",
            "FA_OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
            "FA_OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
            "ORACLE_WALLET",
            "OCI_SIGNATURE_VERSION1",
            "SASLPLAIN",
            "SASLPLAIN_OVER_SSL",
            "SASLPLAIN_OVER_SSL_OSS",
            "TLS",
            "MUTUAL_TLS",
            "UIPATH_CLOUD",
            "AS2_ADVANCE_SEC_PROPS",
            "AS2_BASIC_SEC_PROPS"
        ]
    }
}

Nested Schema : adaptericons

Type: object

Show Source

largeIconUrl(optional): string
mediumGrayIconUrl(optional): string
mediumIconUrl(optional): string
mediumWhiteIconUrl(optional): string
smallIconUrl(optional): string

{
    "type":"object",
    "properties":{
        "smallIconUrl":{
            "type":"string"
        },
        "mediumIconUrl":{
            "type":"string"
        },
        "largeIconUrl":{
            "type":"string"
        },
        "mediumGrayIconUrl":{
            "type":"string"
        },
        "mediumWhiteIconUrl":{
            "type":"string"
        }
    },
    "xml":{
        "name":"adaptericons"
    }
}

Nested Schema : links

Type: array

Show Source

Array of: object SuiteLink

{
    "type":"array",
    "items":{
        "$ref":"#/definitions/SuiteLink"
    }
}

Nested Schema : oauth3LeggedSupport

Type: array

Show Source

Array of: string

Allowed Values: [ "BASIC_AUTH", "USERNAME_PASSWORD_TOKEN", "USERNAME_PASSWORD_IGNORE_TIMESTAMP", "OAUTH_CLIENT_CREDENTIALS", "OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS", "SAML", "OAUTH", "CUSTOM", "TEMPLATE_BASED", "TOKEN_BASED", "NONE", "PLUGIN_AUTHORIZATION_CODE_CREDENTIALS", "TIMEOUT_AUTHORIZATION_CODE_CREDENTIALS", "PLUGIN_RESOURCE_OWNER_PASSWORD_CREDENTIALS", "PLUGIN_CLIENT_CREDENTIALS", "MIN_PLUGIN_AUTHORIZATION_CODE_CREDENTIALS", "OAUTH_AUTHORIZATION_CODE_CREDENTIALS", "OAUTH20_AUTHORIZATION_CODE_CREDENTIALS", "CUSTOM_THREE_LEGGED", "CUSTOM_TWO_LEGGED", "CUSTOM_SINGLE_TOKEN", "OAUTH_ONE_TOKEN_BASED", "NETSUITE_TOKEN_BASED", "PAAS_INTEGRATION_USING_OWSM_OAUTH20", "FTP_PUBLIC_KEY_AUTHENTICATION", "FTP_MULTI_LEVEL_AUTHENTICATION", "OAUTH_INBOUND", "AWS_SIGNATURE_VERSION4", "OAUTH2_PRECONFIGURED_CLINET_ID_SECRET", "OAUTH2_CCS_ROP_PRECONFIGURED", "OAUTH2_CCS_ROP", "OAUTH2", "CCS_BASIC_AUTH", "CCS_API_KEY", "JDBC_OVER_SSL", "JDBC_BASIC_AUTH", "FA_OAUTH_AUTHORIZATION_CODE_CREDENTIALS", "FA_OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS", "ORACLE_WALLET", "OCI_SIGNATURE_VERSION1", "SASLPLAIN", "SASLPLAIN_OVER_SSL", "SASLPLAIN_OVER_SSL_OSS", "TLS", "MUTUAL_TLS", "UIPATH_CLOUD", "AS2_ADVANCE_SEC_PROPS", "AS2_BASIC_SEC_PROPS" ]

{
    "type":"array",
    "items":{
        "type":"string",
        "enum":[
            "BASIC_AUTH",
            "USERNAME_PASSWORD_TOKEN",
            "USERNAME_PASSWORD_IGNORE_TIMESTAMP",
            "OAUTH_CLIENT_CREDENTIALS",
            "OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
            "SAML",
            "OAUTH",
            "CUSTOM",
            "TEMPLATE_BASED",
            "TOKEN_BASED",
            "NONE",
            "PLUGIN_AUTHORIZATION_CODE_CREDENTIALS",
            "TIMEOUT_AUTHORIZATION_CODE_CREDENTIALS",
            "PLUGIN_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
            "PLUGIN_CLIENT_CREDENTIALS",
            "MIN_PLUGIN_AUTHORIZATION_CODE_CREDENTIALS",
            "OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
            "OAUTH20_AUTHORIZATION_CODE_CREDENTIALS",
            "CUSTOM_THREE_LEGGED",
            "CUSTOM_TWO_LEGGED",
            "CUSTOM_SINGLE_TOKEN",
            "OAUTH_ONE_TOKEN_BASED",
            "NETSUITE_TOKEN_BASED",
            "PAAS_INTEGRATION_USING_OWSM_OAUTH20",
            "FTP_PUBLIC_KEY_AUTHENTICATION",
            "FTP_MULTI_LEVEL_AUTHENTICATION",
            "OAUTH_INBOUND",
            "AWS_SIGNATURE_VERSION4",
            "OAUTH2_PRECONFIGURED_CLINET_ID_SECRET",
            "OAUTH2_CCS_ROP_PRECONFIGURED",
            "OAUTH2_CCS_ROP",
            "OAUTH2",
            "CCS_BASIC_AUTH",
            "CCS_API_KEY",
            "JDBC_OVER_SSL",
            "JDBC_BASIC_AUTH",
            "FA_OAUTH_AUTHORIZATION_CODE_CREDENTIALS",
            "FA_OAUTH_RESOURCE_OWNER_PASSWORD_CREDENTIALS",
            "ORACLE_WALLET",
            "OCI_SIGNATURE_VERSION1",
            "SASLPLAIN",
            "SASLPLAIN_OVER_SSL",
            "SASLPLAIN_OVER_SSL_OSS",
            "TLS",
            "MUTUAL_TLS",
            "UIPATH_CLOUD",
            "AS2_ADVANCE_SEC_PROPS",
            "AS2_BASIC_SEC_PROPS"
        ]
    }
}

Nested Schema : VendorInfo

Type: object

Show Source

contactUS(optional): string
description(optional): string
documentationURL(optional): string
name(optional): string
releaseNotes(optional): string
supportURL(optional): string

{
    "type":"object",
    "properties":{
        "supportURL":{
            "type":"string"
        },
        "name":{
            "type":"string"
        },
        "description":{
            "type":"string"
        },
        "contactUS":{
            "type":"string"
        },
        "documentationURL":{
            "type":"string"
        },
        "releaseNotes":{
            "type":"string"
        }
    }
}

Nested Schema : SuiteLink

Type: object

Show Source

href(optional): string
mediaType(optional): string
rel(optional): string

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        },
        "mediaType":{
            "type":"string"
        }
    }
}

Nested Schema : Link

Type: object

Show Source

href(optional): string
mediaType(optional): string
rel(optional): string

{
    "type":"object",
    "properties":{
        "rel":{
            "type":"string"
        },
        "href":{
            "type":"string"
        },
        "mediaType":{
            "type":"string"
        }
    }
}

Nested Schema : SuiteLookupRowData

Type: object

Show Source

rowData(optional): array rowData

{
    "type":"object",
    "properties":{
        "rowData":{
            "type":"array",
            "items":{
                "type":"string"
            }
        }
    }
}

Nested Schema : rowData

Type: array

Show Source

Array of: string

{
    "type":"array",
    "items":{
        "type":"string"
    }
}

Nested Schema : items

Type: array

Show Source

Array of: string

{
    "type":"array",
    "items":{
        "type":"string"
    }
}

Response

Supported Media Types

application/json; charset=utf-8

200 Response

Successful operation

400 Response

Bad request, missing required data

500 Response

Server error

Examples

The following example shows how to create a lookup by submitting a POST request on the REST resource using cURL. For more information about cURL, see Use cURL. For more information about endpoint URL structure, see Send Requests.

This command creates a lookup with the name and values specified in the request body.

The command consumes JSON data.

curl -X POST -H 'Authorization: Bearer access_token' -H "Content-Type:application/json" -d @lookup.json https://integration.us.oraclecloud.com/ic/api/integration/v1/lookups

Example: Request Body to map country codes to country names

The following example shows the contents of a request body in JSON format. This is the contents of the lookup.json file listed in the cURL command with the -d option.

In this example, we are mapping the short country codes to the country names.

Let's say we have these country codes:

IN India
USA United States
CA Canada
FR France
GR Germany

We can create a lookup called CountryLookup to map these values and then reference this lookup in any integration. Note that you can have as many columns as needed, but here we only needed two columns.

{"columns":["CountryCode","CountryName"],"rows":[{"rowData":["IN","India"]},{"rowData":["USA","United States"]}, {"rowData":["CA","Canada"]},{"rowData":["FR","France"]},{"rowData":["GR","Germany"]},],"name":"CountryLookup"}