The inspection API can return a lot of detail about a data source, including all the columns and data types, sample information, definition information, etc.
## cURL
curl "https://<YOUR API ENDPOINT>/inspection/input/inspect/<YOUR DATA SOURCE ID>/" \
-H 'Content-Type: application/json' \
-H 'Authorization: <YOUR API KEY>' \
This API call will return all of the configuration and metadata for the data source.
{
"operation": {
"clazz": "UploadFileInput",
"id": "redacted",
"globalId": "redacted",
"organizationId": "redacted",
"computeEnvironment": "redacted",
"connectionPointer": "redacted",
"displayData": {
"name": "test",
"description": "",
"creationTime": "2020-09-12T14:25:56.344935Z",
"createdBy": "Yoni Iny (yoni@upsolver.com)",
"modifiedTime": "2020-09-12T14:25:56.415150Z",
"modifiedBy": "Yoni Iny (yoni@upsolver.com)",
"versionId": "1e14e06b-6f44-4693-ba8a-aaf73ddaaa1a"
},
"contentType": {
"clazz": "CsvContentType",
"inferTypes": false,
"header": "a,b,c,d,e,f,g,h,i",
"delimiter": ",",
"nullValue": "\\N",
"nestedJsons": [],
"keepOriginalNestedJsonString": false,
"headers": [
"a",
"b",
"c",
"d",
"e",
"f",
"g",
"h",
"i"
]
},
"startExecutionFrom": "2020-09-12T14:23:00Z",
"folder": "uploads/d967c7c8-2d87-4154-a455-4fdbcb582048",
"isDeleted": false,
"version": 48,
"workspaces": [],
"previewId": "d5a4c870ad88e4f886a0ec2a95bb175d",
"executionParallelism": 1,
"status": {
"clazz": "Running"
},
"safeStartTime": "2020-09-12T14:23:00Z"
},
"fields": [
{
"name": "data.a",
"nativeType": {
"name": "string",
"isArray": false,
"subFields": []
}
},
...
{
"name": "time",
"nativeType": {
"name": "number",
"isArray": false,
"subFields": []
}
}
],
"availableSamples": [
{
"events": 29,
"failures": 0,
"time": "2020-09-12T14:00:00Z"
},
...
{
"events": 0,
"failures": 0,
"time": "2020-09-22T20:00:00Z"
}
],
"lastUpdate": "2020-09-22T20:35:00Z",
"lastInsertTime": "2020-09-22T20:35:00Z",
"customFields": []
}
Comments
0 comments
Article is closed for comments.