Skip to main content

Hello All,

We want to setup a action flow to refresh 1 table from a data model. Is there any way to do it using action flow?

 

Thanks in advance.

Hi @amey.punek12,

 

This might be possible, but I do not know the exact end-point you should use. You can for instance see the load status of a Data Model via the Celonis API as described in the PyCelonis Docs:

 

/integration/api/pools/{pool_id}/data-models/{datamodel_id}/load-history/load-info-sync

 

Please have a look at the developer docs, to see how to connect to the API (i.e. authorization): https://developer.celonis.com/data-ingestion-api/getting-started/

 

The only thing you have to figure out if how the endpoint above should be adjusted to run a partial reload. I checked the PyCelonis code and couldn't find it, but maybe you've more luck: https://celonis.github.io/pycelonis/2.7.0/reference/pycelonis/ems/data_integration/data_model/#pycelonis.ems.data_integration.data_model.DataModel.partial_reload


Yes, I don't know if this is the best way for this goal, but you can configure a skill which simply reloads a data model. Then I believe you'd setup an action flow only with the execute automation skill module (which you link to the aforementioned skill)


Hi @amey.punek12 -

We are doing this by triggering an ML script by using Action flow.

ML script will execute the data job where the data model is attached with a partial load of required table.

 


Reply