URGENT. Issue with the Date Time filter with API call.

[ashutoshbhoyar]

Issue description

I am currently attempting to retrieve records using the following URL: "https://***/v1/Items?$filter=UpdateDate ge '2024-12-02' and UpdateTime ge '18:49:00'". My objective is to obtain records corresponding to 2024-12-03. However, the results I am receiving do not align with my expectations.

Upon reviewing the documentation for the SAP Business One Service, I noted the following points: "Please be aware that SAP Business One disregards the HOUR/MINUTE/SECOND components. Additionally, the keyword prefix 'datetime' may be utilized before the datetime value," and "Be informed that SAP Business One ignores the YEAR/MONTH/DAY components; only the HOUR/MINUTE components are relevant."

I would like some guidance on how to correctly apply the filter to obtain the desired records. Any assistance in this matter would be greatly appreciated.

Feedback Type (Optional)

None

Page Title on SAP Help Portal (prefilled)

SAP Integration Advisor

Page URL on SAP Help Portal (prefilled)

https://help.sap.com/docs/cloud-integration/sap-cloud-integration/sap-integration-advisor

[SrutiSagaram]

Hi @ashutoshbhoyar

Thank you for the feedback. We will check and get back to you.

[ashutoshbhoyar]

Hi, @SrutiSagaram Thank you so much for your assistance. Could you please let me know the ETA for the solution? I’d appreciate it!

[SrutiSagaram]

Hi I’ve assigned this to the appropriate author and she will determine if this information can be provided in the documentation. However this is not the right channel if you are looking for support. This is for documentation feedback. We cannot provide a ETA for this. If you need support urgently please raise a support ticket by checking the appropriate component in the troubleshooting section of the guide. Regards, Sruti On 24 Jan 2025, at 6:41 PM, ***@***.*** wrote:  Hi, @SrutiSagaram<https://github.com/SrutiSagaram> Thank you so much for your assistance. Could you please let me know the ETA for the solution? I’d appreciate it! — Reply to this email directly, view it on GitHub<#115 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALOV76NT4S3BD2SBHSJH4K32MI3XFAVCNFSM6AAAAABVZH4I3SVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDMMJSGQ4TQNBUHA>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[SrutiSagaram]

Hi @ashutoshbhoyar

On reviewing the information you've provided, I can see no connection between the product you've raised this for (SAP BusinessOne) and the documentation that you've raised the ticket for - which pertains to SAP Integration Suite.
Moreover as I've explained, this is a channel to provide documentation feedback. Hence closing the ticket.