0

Has anyone been able to query Magento 2 (any entity, but I am specifically using orders) using the XML data source in SSRS Report Builder? I am having difficulty structuring the connection string. If I send the URI I actually want:

https://www.myurl.com/shop/rest/V1/mycompanyname/orders?searchCriteria[filter_groups][0][filters][0][field]=created_at&searchCriteria[filter_groups][0][filters][0][value]=4/9/2019%2017:12:00&searchCriteria[filter_groups][0][filters][0][condition_type]=from&searchCriteria[filter_groups][1][filters][1][field]=created_at&searchCriteria[filter_groups][1][filters][1][value]=4/10/2019%2023:59:00&searchCriteria[filter_groups][1][filters][1][condition_type]=to

I get a return that the connection string is invalid. I have tried just the namespace https://www.myurl.com/shop/ and it accepts that, but then I cannot connect in the query. Somewhere in there, I also need to send the Authorization header, but I just don't know where to start. I would appreciate any pointers.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.