operational reporting for procurement synchronous api

[MOHAMMED_TAMBOLI]

Hallo Team/Experts.

I have the base URL for Operational Procurement API

https://openapi.au.cloud.ariba.com/api/procurement-reporting-view/v2/prod.

I would like frame the URL to fatch present invoice status from Ariba from Jan 2025 to Present. I am not aware to frame the URL for the requirement and need help if anyone can provide input to frame the URL which will be greatful as I am new working with API's.

Still need any additonal information I can provide.

Thanks

[SiruiLiu]

Hi,

try this out:

https://openapi.au.cloud.ariba.com/api/procurement-reporting-details/v2/prod/views/Invoice_SAP_createdRange?filters=%7B%22createdDateFrom%22:%222025-01-01T00:00:00Z%22,%22createdDateTo%22:%222025-03-24T23:59:59Z%22%7D&realm={you ariba realm id}

Please noted the filter value should be encoded.

Best regards,

Sirui

[MOHAMMED_TAMBOLI]

Hi SiruiLiu, So kind of you for immediate response, additional doubts about the note. What filter value should be encoded. could you please some details on it. Thanks in advance

[MOHAMMED_TAMBOLI]

Also since its new API, This needs to be set in Postman right?

[SiruiLiu]

Hi @MOHAMMED_TAMBOLI 

the filter value "%7B%22createdDateFrom%22:%222025-01-01T00:00:00Z%22,%22createdDateTo%22:%222025-03-24T23:59:59Z%22%7D" is encoded already, the decoded version is "{"createdDateFrom":"2025-01-01T00:00:00Z","createdDateTo":"2025-03-24T23:59:59Z"}".

You can use post man to test this API, let me know if you need more information.

[MOHAMMED_TAMBOLI]

Hi SiruiLiu, I tried to post with the below URL by adding my re realm id. but getting error message - No API Key found in Request. i.e.

[MOHAMMED_TAMBOLI]

Can you please advise

[SiruiLiu]

Hi MOHAMMED_TAMBOLI, yes you should apply the application in developer portal fristly, then you should have the application key and secrect password. You may check this help doc https://help.sap.com/docs/ariba-apis/help-for-sap-ariba-developer-portal/steps-to-start-using-sap-ar...

[MOHAMMED_TAMBOLI]

Hi SiruiLiu, Thanks!! I will check and link.

[MOHAMMED_TAMBOLI]

I would like to add other fields i.e Invoice ID also needs to be facthed in the report, so how can I include that to get the ID in the report.

[SiruiLiu]

If you want to include more fields for fitering, you need create your own custom template and put the filed like invoice ID as filterExpressions. You can check this like for futher details: https://help.sap.com/docs/ariba-apis/analytical-reporting-api-for-strategic-procurement-and-operatio...

[MOHAMMED_TAMBOLI]

Hallo Siruiliu. Great and Thanks for the input, I just framed custom template. will this suffice to fetch single invoice or multiple invoice report.

[MOHAMMED_TAMBOLI]

{

"documentType":"Invoice"

"status":"Approved","Rejected","Paid"

"selectAttributes":["InvoceId"],

"filterExpressions" : [

{

"field" : "TimeUpdated",

"op" : "<=",

"defaultValue" : "2025-03-31T00:00:00Z",

"name" : "updatedDateTo"

},

{

"field" : "TimeUpdated",

"op" : ">",

"defaultValue" : "2025-03-001T00:00:00Z",

"name" : "updatedDateFrom"

}

]

}

[SiruiLiu]

In custom template you can fetch multiple document and for sure single document is also working