Forum Discussion

mcfarmer's avatar
mcfarmer
Data Storage
03-26-2022

REST API v2 Dataset Bigquery

Hi! I have been trying to get familiar with the REST Api and managed to connect & create a datamodel through a Python script. Now for the next step I would like to create a dataset in this datamode...
Data Connectors
AshtonW's avatar
AshtonW
Sisense Employee
04-01-2022

Hi mcfarmer ,

The easiest way to figure out the parameters and the formatting of the parameters is to create a new connection through the Sisense GUI,
then use the GET datamodels/schema endpoint to get the payload for the connection.


To do this, first, create a new live model in the Sisense GUI. Then click the "+ Data" button and configure your BigQuery connection.

Finally, send a GET request to /api/v2/datamodels/schema?title=<your_model_name>. You can get the parameters by indexing into the response object (datasets -> 0 -> connection -> parameters).

Note that some of the parameters are optional.

Hope this helps!
- Ashton