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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.