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.

[gokul_raj97]

Hi, we are trying to get the pr data using operational reporting api. But sometimes the currency appears to be in different format if it is other than usd. Which field will give the line item amount and total cost exactly

[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.

[former_member729060]

The reason would be the default filters are taking into consideration for the TimeCreated, You can override the existing date filters and give a try again.

If still issues you can reach out to me via Slack or teams

[kaichu]

Hi Dileep,

Thanks for your quick response. We override the existing date filters using status in url and it is returning empty records. please see below

%7B%22StatusStrings%22%3A%22Received%22%7D.