get all cubes, tables and it's respective row count

[john2ll]

Hi Guys,I'm new to sisense and I was trying to get a list of all the cubes,all underlying tables, respective row counts, column names and the datatype.

I'm trying to hit endpoint to get the relevant data but it is having too much data which is not needed.

url - https://siense.com/api/v2/datamodels/schema

[HamzaJ]

Hey @john2ll ,

Almost every sisense endpoint has the query parameter fields and limit. With fields you can choose the fields you want to be shown and with limit the amount of results. This should help you create a more smaller dataset

Hamza

[DRay]

Hello @john2ll,

I’m following up to see if the solution offered by @HamzaJ worked for you.

If so, please click the 'Accept as Solution' button on the appropriate post. That way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.