Wanneer ik een request in de UniversalSQL-editor uitvoer:
select *
from VismaNet.GeneralLedgerTransactions.GeneralLedgerTransactions
( COMPANY_CODE = 'compcode'
)
krijg ik de volgende foutmelding:
itgensql001
Unknown identifier ‘COMPANY_CODE’.
There are no similar identifiers.
Terwijl de tabel juist om dit onderdeel lijkt te vragen:
select *
from VismaNet.GeneralLedgerTransactions.GeneralLedgerTransactions
( :COMPANY_CODE -- Partition to retrieve data from.
, :branch -- The branch CD
, :ledger -- Mandatory. The ledger in which you want to view the account balances.
, :fromPeriod -- The financial period that begins the date range of the batches you want to view. Format YYYYPP
, :toPeriod -- The financial period that ends the date range of the batches you want to view. Format YYYYPP
, :account -- The account CD for which you want to view activities in the selected financial period.
, :subaccountId -- The Subaccount
, :fromDate -- The first date of the interval within the period. Format YYYY-MM-DD
, :toDate -- The last date of the interval within the selected period. Format YYYY-MM-DD
, :includeUnposted -- Checkmark indicating if unposted batches are included.
, :includeUnreleased -- Checkmark indicating if unreleased (balanced) batches are included.
, :skipRecords -- This field has been deprecated and will be removed in future versions. Use pagenumber and pagesize for pagination purposes. Pagenumber and pagesize does not work with NumberToRead and SkipRecords.
, :numberToRead -- This field has been deprecated and will be removed in future versions. Use pagenumber and pagesize for pagination purposes. Pagenumber and pagesize does not work with NumberToRead and SkipRecords.
, :lastModifiedDateTime -- This value, generated by the system, indicates the last time the record was modified. Use it to retrieve all records that have been modified since that time, up to the present. Accepted format: * ```yyyy-MM-dd``` * ```yyyy-MM-dd HH:mm:ss``` * ```yyyy-MM-dd HH:mm:ss.FFF``` * ```yyyy-MM-ddTHH:mm:ss``` * ```yyyy-MM-ddTHH:mm:ss.FFF``` _Note:_ __LastModifiedDateTime__ and __LastModifiedDateTimeCondition__ are __mutually inclusive__.
, :lastModifiedDateTimeCondition -- This value represents the condition to be applied when retrieving records. Accepted values (without the single quotes): * '>' for greater than * '<' for less than * '>=' for greater than or equal * '<=' for less than or equal _Note:_ __LastModifiedDateTime__ and __LastModifiedDateTimeCondition__ are __mutually inclusive__.
, :expandAccountInfo -- By default, if no value is provided, False and the account information will include only Number, Description, Type and GlConsolAccountCD. If True, each transaction returned will include extended information about account.
, :expandBranchInfo -- By default, if no value is provided, False and branch information will include only branch number. If True, each transaction returned will include extended information about Branch (number and name).
, :includeTransactionBalance -- By default, if no value is provided, False and the transactions returned will not include their balances (fields BegBalance, EndingBalance, CurrBegBalance, CurrEndingBalance) If True, each transaction returned will include its balance.
, :pageNumber -- Pagination parameter. Page number.
, :pageSize -- Pagination parameter. Number of items to be collected. Please use a page size lower or equal to the allowed max page size which is returned as part of the metadata information. If requested page size is greater than allowed max page size, request will be limited to max page size.
, :erp-api-background -- If a URL value is provided, then API endpoint will be queued and executed in background. When the execution of the background operation is finished, the system will POST the response to the specified URL. The endpoint itself responds in this case with a 202-Accepted status and a reference to a state document for the background operation.
)
Als ik gebruik maak van unnamed paremeters doet hij het wel maar hiermee kan ik niet bereiken wat ik wil bereiken (oftewel niet alle parameters invullen).
Hoe moet ik het request uitvoeren om wel resultaat te krijgen?
