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

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

john2ll

Posted 1 year ago·Last reply 1 year ago

3 comments

DRay

·1 year ago

Hi john2ll,

There is an API based solution that we can help with. If we provide the steps are you comfortable executing it? If not, we can connect you with a resource who can help.

Please let us know.

Thank you.

DRay

·1 year ago

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.

HamzaJ

·1 year ago

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