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.
