SAP Build Process Automation date type key in action error

[Former Member]

Hello all!

I'm facing an interesting error while using the actions in SAP Build Process Automation. I'm trying to query the equipment API from on premise S/4HANA system using an action, and I'm getting this error:

The request has a malformed URI syntax. The "ValidityEndDate" is not correct. It should be like:

As you can see in the image above, it works out fine in actions editor. I've tried a few things, including parsing, modifying the property and even adding a default value for the "ValidityEndDate", but I still get that malformed URI syntax.

Anyone has come across this error? If you have any idea, please let me know.

Best regards,
Rafael

[Former Member · Accepted solution]

Hello!

I've taken a new look into this issue and found an answer. There is a difference between the S/4HANA on-premise and Cloud versions for this API: the type for the date key. This would be expected, but I didn't notice it when looking at the metadata:

The difference can be seen here in the actions page:
-Cloud:

-Onpremise:

Lesson learned: Get the correct API for the correct backend. This incorrect date type was the reason why I couldn't query correctly using the date encoded (9999-12-31T00:00:00 to 9999-12-31T00%3A00%3A00) in the cloud API specification with an on-premise backend.

Now I've imported the correct API specification, and it works as expected. However, I'm still not sure how I would parse the date for the Cloud edition.

If anyone has any ideas, I would appreciate if you could share them.

Best regards,
Rafael