Skip to Content
0
May 19, 2020 at 10:54 AM

internal representation of date when using variable in WebService Query_View_Data

60 Views

Hi,

I'm using the Webservice Query_View_Date to retrieve BEx query results via SOAP. All variables are filled following the documented style: VAR_VALUE_NAME and VAR_VALUE_EXT. Unfortunately while it is possible to use the internal representation of values when using background filters, with variable only the external format is supported. This causes problems when it comes to dates. The external representation can be defined by the user in SU3 (e.g. MM/DD/YYYY or DD.MM.YYYY), so an external webservice consumer cannot know the valid format as it has no access to the user settings.

I could now implement something like a WS-Proxy to handle different date formats, but that would mean an additional custom development which is not wanted.

Any other ideas how to circumvent this problem?

Thansk a lot!

Joe