Endpoints Visma.net Suppliers et SupplierAttributes échouent partiellement à cause d'une configuration de colonne défectueuse

Questions (en)
, , ,
1

A while ago I have been getting the following error when calling the Visma.Supplier.Suppliers endpoint and the Visma.Supplier.SupplierAttributes endpoint, because of the timestamp column. This column is strangely configured, and I am getting this error when trying to connect via some apps like Azure Data Factory. Even via Power BI, this data is not interpretable.

Column: timeStamp,The data type ByteArray is not supported from the column named timeStamp.

This does not occur at other tables such as Customers or CustomerAttributes. Would it be possible for you to remove this column all together from the results from the call?

image
image663×414 17.3 KB

Bestanden combineren
De indeling van uw eerste bestand () wordt niet herkend.
Filter de lijst met bestanden zodat deze alleen ondersteunde typen bevat (tekst, CSV, Excel-werkmappen enzovoort) en probeer het opnieuw.

2

Field timestamp

The field timestamp can be retrieved in the SQL tool as follows:

select timestamp
from   Suppliers

resulting in a binary output, which offers an Invantive SQL editor as a download:

image
image705×353 15.9 KB

The corresponding data type can be retrieved as follows:

select name
,      database_data_type
,      dotnet_data_type
from   SystemTableColumns@datadictionary
where  table_name = 'Suppliers'
and    name = 'timeStamp'

with result being blob cq. byte[]:

image
image779×388 18.3 KB

The Visma.net documentation specifies that the timestamp column is intended as binary data with specific functionality:

        "timeStamp": {
          "format": "byte",
          "description": "Identifier that represents a specific version of the resource.\r\nIt helps to prevent simultaneous updates of the resource from overwriting each other (by using ETags and If-Match headers)",
          "type": "string"
}

Starting points

From your description, it seems that Power BI seems to have problems handling the binary data format by default. The error is not considered a bug in the datamodel of Visma.net Financials, but a limitation of the product or use of the client product.

In general, it is preferred by Invantive to not change the data model functionally due to limitations of a client tool.

Recommendation

It is recommended to check whether the column can be excluded in the OData-query by removing it from the selection or searching for alternative solutions within Power BI.

3

Thanks for the info & suggestions. Would like to say I understand, but even Azure Data Factory doesn’t support it by default. You would have to go at length to be able to exclude the column as it also does not contain anything useful as far as I can tell.

4

Yes, it is not practical, but might have a function. Seems like it contains something like:

When Invantive UniversalSQL Server is live on Invantive Cloud, it will probably be easier to exclude since a query can be entered.

5

Cette question a été automatiquement fermée après au moins une semaine d’inactivité suite à la fourniture d’une solution possible. La dernière réponse donnée a été marquée comme solution.

Veuillez poser une nouvelle question via un sujet séparé si le problème se reproduit. Veuillez inclure un lien vers ce sujet dans la nouvelle question en collant son URL dans le texte.