lookupManagement

Upload a CSV file.

Create a request to populate a lookup table with a CSV file.

post/v1/lookupTables/{id}/upload

Request

  • Base URL
    https://api.au.sumologic.com/api
  • URL
    https://api.au.sumologic.com/api/v1/lookupTables/{id}/upload
  • Auth
    HTTP basic

Path parameters

idstring required
Example:0000000001C41EE4

Identifier of the lookup table to populate.

Query parameters

mergeboolean
Example:true

This indicates whether the file contents will be merged with existing data in the lookup table or not. If this is true then data with the same primary keys will be updated while the rest of the rows will be appended. By default, merge is false. The response includes a request identifier that you need to use in the Request Status API to track the status of the upload request.

fileEncodingstring
Example:UTF-16

File encoding of file being uploaded.

Request body multipart/form-data

filestring binary required

The CSV file to upload.

  • The size limit for the CSV file is 100MB.
  • Use Unix format, with newlines ("\n") separating rows.
  • The first row should contain headers that match the lookup table schema. Matching is case-insensitive.

Response

The upload request was accepted. Use the provided token in a status request to track the status of the upload.

idstring required

The identifier used to track the request.

Example response

{
  "id": "0000000001C41EF2"
}

Changes

No recorded changes to this operation across all 15 revisions of this API.