Both requests result in List datapills. Why not load them into two SQL Collections then just use SQL joins/queries with the two SQL collections to get the resulting List, then use that resulting List datapill to update/insert into the SharePoint list...
There is the RabbitMQ Webhooks plugin, but it MAY be a bit outdated. (Never used it before, but worth investigating) - neuralegion/rabbitmq-webhooks - Docker Image | Docker Hub
BTW. Workato now has a Delta Lake connector, so you can directly write into Delta Lake within OneLake. Also support the creation of the Delta Lake table and the Read of the data.
If you are just using the Connector SDK and not an OPA extension could you not just code the connector to first retrieve the secret from the Key Vault with a get within the ruby code, then use that result of that get to populate the required details ...
Well the answer is: "it depends" οTo be a little more succinct. it depends on how you are managing data within your Fabric environment. The beauty of Fabric is that it isnt prescriptive and gives you many options for how you manage your data. Here ar...