Create a dataset on SQL query

Creates a new Dataset object based on SQL query.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…

Returns

Returns a new Dataset object if the call succeeded.

The following are the examples of HTTP status codes including errors that API can generate

Response codesResponse contentDescription
200 OKA dataset objectA dataset has been created successfully.
400 Bad RequestProperty 'IntegrationKey' cannot be emptyThe field "IntegrationKey" cannot be empty.
400 Bad RequestProperties 'SQL' and 'FullTableName' are emptyThe fields "FullTableName", "SQL" cannot be empty.
400 Bad RequestThe SQL query that was specified is incorrect.
Body Params
string
required

Name of the Dataset

string
required

Type of Dataset should be 'Custom'

Fields
array of strings
required

The list of fields {"Name":"FieldName","Type":"FieldType"}

Fields*
int32

The ID of an existing folder to add this Dataset to. If nothing is passed, then the Dataset will be created in a root folder.

Headers
string
enum
Defaults to application/json

Generated from available response content types

Allowed:
Responses

Language
Credentials
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json