Refresh Schema via API

We are trying to investigate how we can trigger a Sisense data model (schema) refresh from the API. This call would be made after a data pipeline schema change. We’ll need the calls to make to "Refresh Schema" how it is done in the UI.

Original Community Post by haarishussain : https://community.sisense.com/t5/help-and-how-to/sisense-api-model-refresh/td-p/21719

DRay

Posted 2 years ago·Last reply 2 years ago

4 comments

RAPID BI Support

·2 years ago

Scotty this might be of interest to you? I know we discussed on call if there was an endpoint for this - should save you from hand-crafting columns all the time...

Sushant_Cropin

·2 years ago

Hi DRay

Yes, it is part of the Rest API documented on Sisense.

Admin -> Rest API -> 2.0 -> Builds

DRay

OP2 years ago

Hi Sushant_Cropin.

Thank you for the information. Where did you find that endpoint? Is it documented somewhere?

Sushant_Cropin

·2 years ago

The parameter for triggering a Refresh Schema is "schemaOrigin": "latest"
/api/v2/builds
POST
{
"datamodelId": "",
"buildType": "schema_changes",
"rowLimit": 0,
"schemaOrigin": "latest"
}

The best way we have found is to do the data transformation and then trigger this API call on a separate EC.