Fetch data from SAP Odata with expands

Question

Hi,
We're trying to fetch data from an SAP Odata API and got it to work using AppFlow. The problem is that the AppFlow connector doesn't support connecting it directly to an entity, only the catalog. And when selecting the EntitySet from the catalog, there's no options for query parameters like $expand.  The salesOrder API in SAP will only provide SalesOrderHeader without asking explicitly for an expand to e.g to_Items, to_Partners etc.

Am I right to assume that AppFlow is too basic and that the only option here is to use lambda and write the API call there? The plan is to store the json's on S3 and AppFlow does that with very little work.

Answer

Hello,

Unfortunately, currently Appflow does not support query parameters such as $expand and there is no alternative way available with Appflow service to add the entities you mentioned directly. This feature has already been requested with our development team.

We constantly post all our Appflow service updates on our What's new blog [1], and on our Appflow release notes [2].

[1] https://aws.amazon.com/new/
[2] https://docs.aws.amazon.com/appflow/latest/userguide/doc-history.html

In case of any further queries, kindly open a support case with AWS using the following link:
https://console.aws.amazon.com/support/home#/case/create

Thank you!

Fetch data from SAP Odata with expands

Relevant content