XML.BankLinksEx@eol raises itgenexl084 error

Questions
, ,
1

With Inventive Query Tool latest PROD version 22.0.658 and latest PROD:

select * 
from   ExactOnlineXML.XML.BankLinksEx@eol

raises itgenexl084 error, from Exact Online side:

itgenexl084:
Exact Online itself reports a problem on topic BankLinks:
Mandatory:
Digital postboxExact Online itself reports a problem on record 1 of topic BankLinks:
Mandatory:
Company.
Please contact Exact Online Support directly.
Message ID: adb3cc02-b2db-4d49-a12b-788b4955bba4

Capture d’écran 2024-01-17 à 17.30.06

Could someone advise ?

3

Please see:

or the output of:

select name
,      dotnet_data_type
from   SystemTableFunctionParameters@datadictionary
where  table_name='BankLinksEx'
order
by     sorting_order
Name Dotnet Data Type
division int32
Params_Administration int32
Params_BankCountry string
Params_BankName string
Params_Mailbox string

This table function BankLinksEx is very specific in use. Probably something like the following will work:

use 123123@eol

select *
from   mailboxes@eol mbx
join   ExactOnlineXML.XML.BankLinksEx@eol(division => mbx.Division, Params_Administration => mbx.Division, Params_Mailbox => mbx.ID)

Depending on your actual needs, you might also be served using BankSubscriptions: Exact Online Bankabonnementen - Exact Online API Data Model.