cancel
Showing results for 
Search instead for 
Did you mean: 

Operation Reporting API- Filter issue

kaichu
Explorer
0 Kudos
528

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.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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

kaichu
Explorer

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.

Answers (1)

Answers (1)

0 Kudos

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
Explorer
0 Kudos

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.