Business Central Connector

This article aims to guide you through:

1) Structure of JSON files;
2) Import data from Plugnotes to BC (via the XX14 plugform);
3) Import data from BC to Plugnotes (via our XX13 Plugform).

The strength of Plugnotes in communication via Webservices is its very transparent and identical structure whatever the information to exchange.

The exchanges are done via JSON files. The specificity of Plugnotes is that all exchanges are configured (and controlled) via 2 specific plugforms:

1. XX13 Calls from: To send data to Plugnotes;
2. XX14 Calls to: To send data from Plugnotes to.

1) JSON files Structure

Note: Each plugnote (sheet)

1. Receives upon its creation a unique number in the entire environment of a user (example 1-669);
2. Belongs to a single plugform which itself has a unique PF key (visible) in addition to the non-visible hash of its owner (1-A002);
3. Includes a maximum of 15 fields (Fx) some of which can be tables (Tx);
4. If it is a table field, there is also behind the format and the number of the field (T4), 1 position of the data which is defined by the line number (L1) and the column number (C3);
5. Each appendix is ​​included in an Attachments section and its content is translated into base64 in the JSON.

This explains how the basic structure of each JSON file remains simple regardless of the original plugform. To know the object of each line of the JSON file (except lines 3 and 5), you can consult a plugnote of the Plugform in Plugnotes.

Complete JSON

2) Import data from Plugnotes to the Business Center (via the XX14 plugform)

• In Plugnotes: You must create a specific plugnote in the XX14 that identifies which plugform is concerned by which webservice (14xx).
  
  Connector: you must have the following information to connect the user's Business Center account with their Plugnotes account. This data will be filled in each plugnote of the XX14.
  
  
  
  Available webservices (some are not available with all connectors): 
  

• In Business Central: The JSON files sent by Plugnotes are stored in a specific buffer table which is subsequently processed via the development:
  

1. A mapping parameter table must also be created to allow knowing the programs to launch based on the plugform code received from Plugnotes in the JSON file:
   
   
   
2. So on the BC side, we need to do some development to process the files received from Plugnotes

3) Import data from BC to Plugnotes (Via our Plugform XX13)

• In Business Central: Creation of a Plugnotes configuration table in which the data corresponding to those created in Plugnotes must be put.
  For the creation or modification of a plugnote, the specific development to generate the correct JSON file is done in BC:
  
  
  
  
  
• In Plugnotes: It is necessary to create in the XX13 a specific Plugnote for each Plugform likely to receive a JSON and specify the expected action:

--
Customer Success
If you have any questions, please contact our Customer Success Team