Skip to main content
  • Home
  • Product Ideas
  • Ability to pass filter parameters in the SAP Extractor for OData connection
Implemented

Ability to pass filter parameters in the SAP Extractor for OData connection

Related products:Extractors
  • I
    ibrahim.alsyed
  • M
    Marissa
  • R
    RodrigoRVSN
dinesh.makked
Seasoned

I finally got the SAP Extractor working to extract data from S/4HANA using the OData APIs. The extractor is easy to configure as you can simply provide the Service Root and Resource URI in the config file. The program maps the extracted data with the OData schema to create the Raw table. It even supports the incremental extracts. 

However, I found that we cannot provide the filter parameters in the config file, and it is a huge barrier to adoption. In most cases. we want to limit the data for a set of Maintenance Plants. So, it would be great enhancement for the SAP Extractors to provide the ability to specify filter parameters while using the OData connectivity. 

 

 

 

4 replies

gedi
Seasoned Practitioner
  • gedi
  • Seasoned Practitioner
  • 31 replies
  • December 8, 2023

Thank you for sharing one more your insightful reflection, Dinesh! 

We greatly appreciate your contribution and stay tuned for updates on how we plan to proceed.

gs
Elka Sierra
MVP
Forum|alt.badge.img

Hi @dinesh.makked thanks for your feedback. 

I am a bit puzzle by your feature request, given that the option to filter is already part of the extractor. It is referred in the documentation under the Endpoints as: 

I wonder if there is anything else you are referring to? If yes, it would be very beneficial to get more details. 

Thanks and Regards

Elka

filter

Enter the filter query string. The $filter system query option allows clients to filter a collection of resources from the target SAP OData endpoint. This is an optional parameter.
dinesh.makked
Seasoned
  • dinesh.makked
  • Author
  • Seasoned
  • 11 replies
  • February 14, 2024

Hi @Elka Sierra,

Thanks for your reply! 

You are right about the $filter parameter. If I recall correctly, this option wasn’t available when I originally submitted the feature request. I am glad that we do have the capability to specify the filter parameters now. 

Having said the above, I would like to retract my feature request. 

I appreciate your help with this matter.

 

Regards,

Dinesh

 

Elka Sierra
MVP
Forum|alt.badge.img

Hi @dinesh.makked , very happy to hear we are already covering the request in the product. 

Please do not hesitate to reached out if you have any other request. 

Thanks and regads

Elka

Reply


Terms & ConditionsCookie Settings

Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings