In Connectivity studio, usually, you can design the integration setup by configuration. Sometimes, it can be required to use a customization. This topic explains the standard document handler classes in Connectivity studio and how to customize these classes. Only use customized classes if you really need specific functionality.

Standard document handler classes - External documents - File based

For external file-based documents, several standard handler classes are available. Each external file-based document type has its own handler classes:
 

Document type

Handler class

Description

XML

BisDocumentXml

This handler class reads data from or writes data to XML files.

BisDocumentXmlV3

On a message, you can use an XML document in combination with a connector of type Web service, Blob storage, or Upload and download. If you do so, use this handler class instead of BisDocumentXml .

JSON

 

BisDocumentJson and BisDocumentJSONv2

These handler classes read data from or write data to JSON files. You are advised to use the 'BisDocumentJSONv2' handler class.

BisDocumentJSONV3

On a message, you can use a JSON document in combination with a connector of type Web service, Blob storage, or Upload and download. If you do so, use this handler class instead of BisDocumentJSONv2.

Text

 

BisDocumentText

This handler class reads data from or writes data to text file s.

BisDocumentTextV3

On a message, you can use the Text document in combination with a connector of type Web service, Blob storage, or Upload and download. If you do so, use this handler class instead of BisDocumentText .

Fixed text

BisDocumentFixedText

This handler class reads data from or writes data to text files with defined start positions and lengths for records and fields.

BisDocumentFixedTextV3

On a message, you can use a Fixed text document in combination with a connector of type Web service, Blob storage, or Upload and download. If you do so, use this handler class instead of BisDocumentFixedText .

EDI

BisDocumentEdi

This handler class reads data from or writes data to a text file using an EDI standard, for example, EDIFACT or ANSI X12.

BisDocumentEDIFACTCounter

This handler class reads data from or writes data to a text file using EDIFACT. With this handler class, you can apply numbering and control counts to your EDI messages. The numbering and counts are only applied on write.

BisDocumentEdiV3

On a message, you can use the EDI document in combination with a connector of type Web service, Blob storage, or Upload and download. If you do so, use this handler class, instead of BisDocumentEdi .

BisDocumentEDIFACTCounterV3

On a message, you can use the EDI document in combination with a connector of type Web service, Blob storage, or Upload and download. If you do so, use this handler class, instead of BisDocumentEDIFACTCounter .

Microsoft Excel

BisDocumentExcel

This handler class reads data from or writes data to Microsoft Excel files using Open XML.

BisDocumentExcelV3

On a message, you can use the Microsoft Excel document in combination with a connector of type Blob storage or Upload and download. If you do so, use this handler class instead of BisDocumentExcel .

Microsoft Word

BisDocumentWord

This handler class writes data to Microsoft Word files using Open XML.

BisDocumentWordV3

On a message, you can use the Microsoft Word document in combination with a connector of type Blob storage or Upload and download. If you do so, Use this handler class instead of BisDocumentWord .

Standard document handler classes - External documents - ODBC

For external ODBC documents, several standard handler classes are available:
 

Document type

Handler class

Description

ODBC

BisDocumentODBC

This handler class directly reads data from or writes data to an external database.

BisDocumentODBCCData

This handler class directly reads data from or writes data to an external CData database via ODBC. The record names and field names must match the ODBC table names and field names. For each record, fill in the External table field in the Line details section.

BisDocumentODBCForDb2

This handler class directly reads data from or writes data to an external DB2 database via ODBC.

 

Standard document handler classes - Internal documents

For internal documents, several standard handler classes are available. Each internal document type has its own handler classes:
 

Document type

Handler class

Description

D365 FO

 

BisDocumentAxDatabase

This handler class reads data from or writes data to D365 FO.

BisDocumentAxDatabase_CompanyHeader

If you use EDI, you can also use this handler class. This handler class imports data into D365 FO. On import, it switches to the company as defined in the EDI history and imports the data into that company.

BisDocumentHistoryAxDatabase

This handler class runs the message from the message history. It is automatically applied if you manually run a message from the message history. So, do not select it for a document.

BisDocumentAxDB_SalesOrderPostInvoice

This handler class creates sales orders and automatically reserves the sales quantities. If the quantities are reserved for a sales order, the sales order invoices are created and posted automatically. If the quantities cannot be reserved, the created sales order is deleted.

BisDocumentAxDB_InventCounting

This EDI-specific handler class creates inventory counting journals.

BisDocumentAxPurchaseOrderAutoConfirm

This handler class imports purchase orders and automatically confirms these purchase orders.

BisDocumentLoyaltyCardPointAdj

This handler class imports loyalty card reward point adjustments. Each adjustment is logged with a unique sequence number.

BisDocumentPickingListRegistration

This handler class imports and creates warehouse orders. When a warehouse order is created, the related picking routes is updated.

BisDocumentAxDB_TransferOrderWave

This handler class creates transfer orders. If a created transfer order is validated, it is automatically released.

BisDocumentAxDB_CustVendTransOpen

This handler class exports open customer transactions or vendor transactions, depending on document record setup.

BisMdmDocumentAxDatabase

This handler class exports data from D365 FO for Master data management (MDM).

Inventory journal

BisDocumentInventJournal

 This handler class imports inventory data into inventory journals. For example: inventory counting results, inventory transfers, or inventory movements. It creates the journal header and links the lines to the created header.

Ledger journal

BisDocumentLedgerJournal

 This handler class imports ledger-related data into ledger journals. For example: ledger allocations or customer payments. It creates the journal header and links the lines to the created header.

BisEdiDocumentLedgerJournalChangeCompany

 If you use EDI, you can also use this handler class. It imports data into the ledger journals. On import, it switches to the company as defined in the EDI history and imports the ledger data into that company.

Trade agreement journal

BisDocumentPriceDiscJournal

This handler class imports trade-agreement-related data into trade agreement journals. For example: discount adjustments or price adjustments. It creates the journal header and links the lines to the created header.

WMS journal

BisDocumentWMSJournal

It creates the journal header and links the lines to the created header.

Report as finished journal

BisDocumentProdParmReportFinish

It creates the journal header and links the lines to the created header.

Production picking list

BisDocumentProdPickList

 It creates the journal header and links the lines to the created header.

Project journal

BisDocumentProjJournal

 It creates the journal header and links the lines to the created header.

Staging

BisDocumentStaging

 This handler class writes data to or reads data from the staging table. On write, the written staging table record is automatically approved. On approval, the data validations are done. On read, only the journals with journal status 'Approved' and message status 'To be processed' are read.

BisStagingDocumentManualApproval

 This handler class writes data to or reads data from the staging table. On write, the data is only written to the staging table. You must manually approve the journals. On approval, the data validations are done. On read, only the journals with journal status 'Approved' and message status 'To be processed' are read.

BisEdiDocumentStagingChangeCompany

 If you use EDI, you can also use this handler class. It imports data into the staging table. On import, it switches to the company as defined in the EDI history and imports the data into that company.

Customize document handler classes

You can use a customized document handler class. To do so, extend a standard document handler class.
For each customized document handler class, you can change these methods as desired:
 

Method

Description

Open

Opens the connection.

onTransactionBegin

Starts the transaction. You can control this method with the Transaction level setting on the message header: Root record or Documents.

onCreateEntity

Returns the entity for a record.

onInitEntity

If the record is not found, it is created.

onWriteField

Writes the value of a field.

onWriteEntity

Writes the entity and defines if it is an update or insert.

onUpdateEntity

Updates the entity.

onInsertEntity

Inserts the entity.

onDeleteEntity

Deletes the entity.

onTransactionCommit

Commits the transaction.

onTransactionAbort

Aborts the transaction.

onErrorEntity

If an error occurs for a source entity, this method is called.

Close

Closes the connection.

See also

Provide feedback