Operation Reporting API- Filter issue

[kaichu]

Hi Team,

We are trying to pull data using operational reporting procurement API and facing issues when using "status" filter. No data on the Response. It is empty

using GETmethod for below end point

"https://openapi.ariba.com/api/procurement-reporting-details/v2/prod/views/myRequisition2?filters=%7B%22StatusStrings%22%3A%22Received%22%7ℜm=<myRealm> "

Can you help me here pls and it behaves same for other status like "Received or Ordered or Ordering".

Below is my custom viewtemplate.

[former_member729060 · Accepted solution]

The filters are inclusive, Can you try {"createdDateFrom":"2022-01-01T00:00:00Z","createdDateTo":"2022-04-11T23:59:59Z","StatusStrings":"Received"}

[kaichu · Accepted solution]

Perfect it worked. Thank you so much!!

Encoded those filter like this %7B%22createdDateFrom%22:%222022-01-01T00:00:00Z%22%2C%22createdDateTo%22:%222022-04-11T23:59:59Z%22%2C%22StatusStrings%22:%22Received%22%7D and it returns values.

[MOHAMMED_TAMBOLI · Accepted solution]

Hallo Kaichu and Team, I am also looking for Operational Reposting for Invoice. I received Base URL but not sure how to frame the URL to get the report of invoice which is Paid or Rejected etc. Could you please help to provice some insite for the requirement as I am new to API.