Calling multiple API from APIM and combine the reponse without using Azure Function App

Question

Hi,
I have trained 3 models from Azure Machine Learning and created API for each model.
I want to create a solution to call all 3 API and combine the responses for me to insert the values into a synapse table or output as file.

Wondering if there is other possible alternative solution to creating an azure function to call all 3 API and combine the reponses?
Thanks,

Answer 1

@Yuzu APIM does have the Send request policy that can help you to send the provided request to the specified URL. You can create multiple send request policies to call different URLs. Based on the response from these policies you can use C# experssion to build your combined request and pass it to your backend service. In your case, you can call the synapse REST services as the backend services to insert the value. Similarly, you can call any of the backend services in APIM that help you to create files in your desired location. If you want to store the file in the azure storage then you can leverage the storage REST API for the same.