support@bipartners.nl | www.bipartners.nl

twinfieldconnect

Twinfield connector for reporting

Using Client Secret

If you have enabled "Require Client Token", you need to add the following header to your request:

CLIENT_TOKEN = ****
.

Return type

The following 2 return types are possible: application/json andapplication/xml. This can be specified using the HTTP header Accept. The default value is XML.

Finder

Example:

https://twinfieldconnect.fintelly.nl/connect/finder/?id={id}&type={type}&dimtype={dimtype (optional)}{filtername=filtervalue}

Find possible filters and filter values at the Twinfield documentation

Name List Y/n Finder type DIM type Comments
General Ledger Accounts DIM BAS or PNL
Suppliers DIM CRD
Customers DIM DEB "matchtype enumeration: DEB, CRD"
Suppliers DIM CRD
Cost centers DIM KPL
Fixed assets DIM AST
Offices OFF
Projects DIM PRJ
Activities DIM ACT
Dimension types DMT
Asset methods ASM
Articles ART
Currencies CUR
Rates TRT
VAT VAT
Hierarchies HIE
Hierarchy nodes HND Filter: accesstype, showrootnode, hierarchy

Browse

https://twinfieldconnect.fintelly.nl/connect/browse/?id={id}&code={code}{bowse_definitions (example: ?fin.trs.head.yearperiod_from=2016/05)}

Code info

Browse code Description
000General ledger transactions
010Transactions still to be matched
020Transaction list
100Customer transactions
200Supplier transactions
300Project transactions
301Asset transactions
400Cash transactions
410Bank transactions
900Cost centers
030_1General Ledger (details)
030_2General Ledger (details) (v2)
031General Ledger (intercompany)
040_1Annual Report (totals)
050_1Annual Report (YTD)
060Annual Report (totals multicurrency)
130_1Customers
130_2Customers (v2)
164Credit Management
230_1Suppliers
230_2Suppliers (v2)
302_1Fixed Assets
610_1Time & Expenses (Totals)
620Time & Expenses (Multicurrency)
650_1Time & Expenses (Details)
651_1Time & Expenses (Totals per week)
652_1Time & Expenses (Totals per period)
660_1Time & Expenses (Billing details)
661_1Time & Expenses (Billing per week)
662_1Time & Expenses (Billing per period)
670Transaction summary
680Bank link details
690Vat Return status
700Hierarchy access

BrowseDefinitions

For filter options check:

https://twinfieldconnect.fintelly.nl/connect/browseDefinitions/?id={id}&code={code}

Hierarchies

https://twinfieldconnect.fintelly.nl/connect/hierarchies?id={id}&hierarchyCode={code}

Webhooks
https://twinfieldconnect.fintelly.nl/connect/webhook

Periods

https://twinfieldconnect.fintelly.nl/connect/periods?id={id}

Bank statements

https://twinfieldconnect.fintelly.nl//connect/bankstatements?id={id}IncludePostedStatements={true or false}&StatementDateFrom=2020-01-01T00:00:00&StatementDateTo=2021-03-30T23:59:59.999+02:00

Read

More detailed information about for example dimensions (example: type=dimensions, dimtype=crd)

https://twinfieldconnect.fintelly.nl/connect/read?id={id}&type={type}&dimtype={dimtype}

List

(List offices; type = offices)
https://twinfieldconnect.fintelly.nl/connect/list?id={id}&type={type}&includeOffice={boolean}

Deleted 030_2 records

(List offices; type = offices)
https://twinfieldconnect.fintelly.nl//deletedtransactions/?id={id}&datefrom=2020-11-29&dateto=2020-11-30&office={office}

VAT return

https://twinfieldconnect.fintelly.nl//connect/declarations/?id={twinfield id}&type=vatReturn