CSVUploads

Retreive all

GEThttps://API_HOST/api/v2/csvuploads

Query parameters

Response

200

List of CSV Uploads

Body

application/json

destinationTable*string

Example: "orders_raw"

destinationSchema*string

Example: "oms"

fileSetstring

Example: "orders_data"

createTime*number

Example: 1660439099000

updateTime*number

Example: 1660445539000

Request

JavaScriptCurlPython

const response = await fetch('https://API_HOST/api/v2/csvuploads', {
    method: 'GET',
    headers: {},
});
const data = await response.json();

Response

200

[
  {
    "destinationTable": "orders_raw",
    "destinationSchema": "oms",
    "fileSet": "orders_data",
    "createTime": 1660439099000,
    "updateTime": 1660445539000
  }
]

Retreive

GEThttps://API_HOST/api/v2/csvuploads/{destinationTable}

Path parameters

destinationTable*string

name of the destinationTable

Query parameters

Response

200

Details about the CSV Upload

Body

application/json

destinationTable*string

Example: "orders_raw"

destinationSchema*string

Example: "oms"

fileSetstring

Example: "orders_data"

createTime*number

Example: 1660439099000

updateTime*number

Example: 1660445539000

Request

JavaScriptCurlPython

const response = await fetch('https://API_HOST/api/v2/csvuploads/{destinationTable}', {
    method: 'GET',
    headers: {},
});
const data = await response.json();

Response

200

{
  "destinationTable": "orders_raw",
  "destinationSchema": "oms",
  "fileSet": "orders_data",
  "createTime": 1660439099000,
  "updateTime": 1660445539000
}

Delete

DELETEhttps://API_HOST/api/v2/csvuploads/{destinationTable}

Path parameters

destinationTable*string

name of the destinationTable

Query parameters

Response

200

csv upload is deleted

Request

JavaScriptCurlPython

const response = await fetch('https://API_HOST/api/v2/csvuploads/{destinationTable}', {
    method: 'DELETE',
    headers: {},
});
const data = await response.json();

Create

POSThttps://API_HOST/api/v2/csvuploads/{dataImportName}/{destinationTable}

Path parameters

dataImportName*string

name of the dataImport

destinationTable*string

name of the destinationTable

Query parameters

Body

multipart/form-data

filestring

Response

200

Details about the created csv upload

Body

application/json

destinationTable*string

Example: "orders_raw"

destinationSchema*string

Example: "oms"

fileSetstring

Example: "orders_data"

createTime*number

Example: 1660439099000

updateTime*number

Example: 1660445539000

Request

JavaScriptCurlPython

const response = await fetch('https://API_HOST/api/v2/csvuploads/{dataImportName}/{destinationTable}', {
    method: 'POST',
    headers: {
      "Content-Type": "multipart/form-data"
    },
    body: JSON.stringify({}),
});
const data = await response.json();

Response

200

{
  "destinationTable": "orders_raw",
  "destinationSchema": "oms",
  "fileSet": "orders_data",
  "createTime": 1660439099000,
  "updateTime": 1660445539000
}

Update

PUThttps://API_HOST/api/v2/csvuploads/{dataImportName}/{destinationTable}

Path parameters

dataImportName*string

name of the dataImport

destinationTable*string

name of the destinationTable

Query parameters

Body

multipart/form-data

filestring

Response

200

Details about the updated csv upload

Body

application/json

destinationTable*string

Example: "orders_raw"

destinationSchema*string

Example: "oms"

fileSetstring

Example: "orders_data"

createTime*number

Example: 1660439099000

updateTime*number

Example: 1660445539000

Request

JavaScriptCurlPython

const response = await fetch('https://API_HOST/api/v2/csvuploads/{dataImportName}/{destinationTable}', {
    method: 'PUT',
    headers: {
      "Content-Type": "multipart/form-data"
    },
    body: JSON.stringify({}),
});
const data = await response.json();

Response

200

{
  "destinationTable": "orders_raw",
  "destinationSchema": "oms",
  "fileSet": "orders_data",
  "createTime": 1660439099000,
  "updateTime": 1660445539000
}

Sample Create Request

import requests

import json

url='https://API_HOST/api/v2/csvuploads/dataImportName/destinationTable'

data={'file':open('path/file.csv')}

authheaders = {'sprinkle-org-id':'OrgId', 'sprinkle-api-key':'key', 'sprinkle-api-secret':'secret'}

r=requests.post(url, files=data, headers=authheaders)

res_json=json.loads(r.text)