SAP Business One

learn how to connect sap business one to engini, enabling efficient integration of your business management processes with the sap business one connector, you can access real time data from your company database, automate tasks like inventory management, sales tracking, and reporting, and enhance operational efficiency integrate sap business one’s robust tools directly into your workflows to streamline your business operations and drive growth getting started with sap business one prerequisites a sap business one account this includes the username and password to access the database connecting engini to sap business one enter your engini account at https //app engini io/ navigate to connections page by clicking on the connections on the left side bar or by clicking https //app engini io/connections click on the “add connection” option located at the top bar choose “sap business one” option from available applications enter the following details in the “add connection” form connection name a unique identifier for the connection within engini service url the sap business one service layer url, typically formatted as https //\<server address> \<port> usually, the port is 50000 company db the name of the specific company database in sap business one to connect to user name the authorized username for accessing the sap business one system password the password associated with the provided username for authentication communication channel specifies whether the connection is for a cloud based or on premises instance of sap business one cloud if you are connecting to a database hosted in a cloud environment, select “cloud” opa if your database is on premises and you are using an on premises agent (opa) for the connection, select “opa” in this case, an additional field will appear on prem agent choose the specific on premises agent that you want to use for this connection if you have multiple agents configured save settings click save when you finnish verifying connection via web browser before configuring engini, you can manually verify the connection using a web browser step 1 open a web browser and navigate to the sap business one service layer login endpoint https // \<server address> \<port>/b1s/v2/login/ replace \<server address> with the actual sap server address and \<port> (usually 50000 ) with the correct port step 2 when prompted, enter the following json structure in the request body { “username” “b1slapp”, “companydb” “companydb binded”, “password” “\<your password>” } replace "b1slapp" with your actual sap business one username replace "companydb binded" with the correct database name enter the correct password step 3 if the request is successful , you will receive a session token in response, indicating that the connection details are correct if the request fails , verify the credentials, database name, and service url activities initialize object array this activity initializes an object array in sap business one and stores a single structured entry based on the selected object type (e g , document lines, additional expenses, or sales opportunities) variable name enter the name of the variable that will hold the object array this name will be used throughout the workflow whenever you refer to this object array object element type define the type of data the array will store it includes a variety of options, such as document lines, additional expenses, sales opportunities, and many others the selected type determines the structure of the array and its use in subsequent actions add field by clicking the “add field” button, you can choose how to fill in the various fields in the object you are creating you can add one field to the activity or more fields to the activity definitions, up to the number of fields you have in the selected object the fields vary depending on the selected object choose from the drop down the field you want to fill click on the empty field to the right of the dropdown to see a tooltip with all the available options you can use to fill the field you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate append to object array this activity adds a new item to an object array that was previously initialized this allows you to dynamically build or update the array with specific elements based on your workflow variable – select the variable representing the object array you want to update the options in this field depend on the object type you selected during the initialize object array activity add field by clicking the “add field” button, you can choose how to fill in the various fields in the object you are creating you can add one field to the activity or more fields to the activity definitions, up to the number of fields you have in the selected object the fields vary depending on the selected object choose from the drop down the field you want to fill click on the empty field to the right of the dropdown to see a tooltip with all the available options you can use to fill the field you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate download attachment this activity allows you to retrieve and download file attachments from sap business one based on their unique identifiers it is useful for accessing documents, images, or other files linked to specific records in the system absolute entry – enter the unique identifier (absolute entry) of the attachment you want to download this ensures the system retrieves the correct file include content – specify whether to include the actual content of the attachment in the download by default, it is set to false set it to true if you need the full file fields – (have only file name) – specify or map the name of the file you want to download this helps identify the attachment by its filename in addition to the absolute entry choose from the drop down the field you want to fill click on the empty field to the right of the dropdown to see a tooltip with all the available options you can use to fill the field you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate upload attachment this activity uploads one or more file attachments to sap business one it is used to attach files such as documents, images, or other resources to specific records or transactions within the system file name – specify the name of the file you want to upload this name will be used to identify the attachment in sap business one content – provide the file content in a suitable format, typically as binary data or a base64 encoded string this is the actual data of the file being uploaded content type – specifies the file’s mime type, which tells sap business one what kind of data the file contains (e g , application/pdf, image/jpeg, text/plain) add file item – use this option to add multiple files for uploading each file can have its own name, content, and content type, allowing batch uploads in a single operation update attachment this activity updates an existing file attachment in sap business one it allows you to modify the file content, name, or type for an attachment associated with a specific record in the system absolute entry – specify the unique identifier (absolute entry) of the attachment you want to update file name – enter the new name for the file if you wish to rename the attachment if left unchanged, the original name will be retained content – provide the updated file content in binary format or as a base64 encoded string this replaces the existing content of the attachment content type – specify the updated mime type for the file (e g , application/pdf, image/jpeg, or text/plain) this ensures sap business one correctly interprets the updated file add file item – use this option to update multiple files each file can have its own name, content, and content type, allowing batch update in a single operation map object array this activity is used to map data from a list into an object array in sap business one data list – provide the list of data that you want to map into the object array this is the source data that will be transformed based on the selected object type object name – select the sap business one object type that defines the structure for the mapping (e g , document lines, sales opportunities, or additional expenses) after selecting a specific object, you will have the option to populate it’s fields by using “add field” add field by clicking the “add field” button, you can choose how to fill in the various fields in the object you are creating you can add one field to the activity or more fields to the activity definitions, up to the number of fields you have in the selected object the fields vary depending on the selected object choose from the drop down the field you want to fill click on the empty field to the right of the dropdown to see a tooltip with all the available options you can use to fill the field you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate execute action this activity triggers specific actions in sap business one based on the selected action type it allows you to perform predefined operations, such as creating, updating, or processing records, as part of your workflow action type – select the type of action to execute the available options may include operations like “create record,” “update record,” “delete record,” and so on the selected action determines the operation performed in sap business one after selecting a specific object, you will have the option to populate it’s fields by using “add field” add field by clicking the “add field” button, you can choose how to fill in the various fields in the record you are creating you can add one field to the activity or more fields to the activity definitions, up to the number of fields you have in the selected object the fields vary depending on the selected object choose from the drop down the field you want to fill click on the empty field to the right of the dropdown to see a tooltip with all the available options you can use to fill the field you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate get record this activity retrieves a single record from sap business one based on the specified object type object type – select the type of object you want to retrieve the available options include the entities “ chart of accounts ,” “ orders ,” “ sales opportunities “ for example object type – chart of accounts retrieves details about a specific account in the company’s chart of accounts code the unique identifier for the account in the company’s chart of accounts output fields optionally specify which fields (e g , account name, balance, etc ) to retrieve from the record object type – orders fetches information about a specific sales or purchase order doc entry the unique identifier for the sales or purchase order this is required to fetch a specific order record output fields choose specific fields to retrieve, such as the order date, total amount, customer name, etc object type – sales opportunities retrieves details about a particular sales opportunity record sequential no the unique sequential number of the sales opportunity this field identifies which opportunity to retrieve output fields optionally select fields to retrieve, like opportunity status, stage, or customer details create record this activity creates a new record in sap business one based on the selected object type it allows you to add new data, such as accounts, orders, or sales opportunities, directly into the system object type – there are 3 object types chart of accounts, orders, sales opportunities after selecting the object type, you have the option to add fields to the object the available fields depend on the selected object type after selecting a specific object, you will have the option to populate it’s fields by using “add field” add field by clicking the “add field” button, you can choose how to fill in the various fields in the record you are creating you can add one field to the activity or more fields to the activity definitions, up to the number of fields you have in the selected object the fields vary depending on the selected object choose from the drop down the field you want to fill click on the empty field to the right of the dropdown to see a tooltip with all the available options you can use to fill the field you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate delete record this activity deletes a specific record in sap business one based on the selected object type it allows you to remove unwanted or obsolete data, ensuring the system remains clean and organized object type – there are 3 object types chart of accounts, orders, sales opportunities after selecting the object type, you must provide the necessary key field (e g , code , document entry or sequential no) to identify the record to be deleted object id this field represents the unique identifier of the selected object record when an object is opened, each record has its own primary identifier the name of this identifier may vary depending on the object type for example, in the business partners object, the unique identifier is called card code for other objects, the identifier may have a different name, but it always represents the specific record to be retrieved or updated update records this activity modifies an existing record in sap business one based on the selected object type it allows you to update details such as account information, order details, or sales opportunity attributes object type there are 3 object types chart of accounts, orders, sales opportunities after selecting the object type, you must provide the necessary key field (e g , code , document entry or sequential no) to identify the record to be updated after selecting a specific object, you will have the option to populate it’s fields by using “add field” add field by clicking the “add field” button, you can choose how to fill in the various fields in the record you are creating you can add one field to the activity or more fields to the activity definitions, up to the number of fields you have in the selected object the fields vary depending on the selected object choose from the drop down the field you want to fill click on the empty field to the right of the dropdown to see a tooltip with all the available options you can use to fill the field you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate get records this activity retrieves multiple records from sap business one based on the selected object type it allows you to fetch data in batches and supports filtering and pagination for precise retrieval object type – select the type of records to retrieve, such as chart of accounts , orders , or sales opportunities the object type defines the structure of the data being retrieve chart of accounts retrieves multiple accounts from the chart of accounts orders fetches a list of sales or purchase orders sales opportunities retrieves multiple sales opportunity records top n– the maximum number of rows to retrieve the default value is 100 offset – the number of rows to skip before retrieving records the default value is 0, which starts retrieval from the first record this field is used for pagination, enabling retrieval of subsequent batches add filter – optionally apply filters to refine the retrieved records filters allow you to specify conditions such as dates, statuses, or other criteria based on the object type add sorting you can sort the retrieved records either ascending or descending get records batch this activity retrieves multiple records from sap business one in a single batch it is designed to handle large data retrievals efficiently, with a maximum batch size of 1000 items this activity is ideal for bulk data operations object type – select the type of records to retrieve, such as chart of accounts, orders, or sales opportunities the object type determines the structure and content of the retrieved data data list – specify or map a list of data identifiers (e g , code, document entries, sequential numbers) to retrieve specific records this ensures precise data retrieval in bulk operations object id this field represents the unique identifier of the selected object record when an object is opened, each record has its own primary identifier the name of this identifier may vary depending on the object type for example, in the business partners object, the unique identifier is called card code for other objects, the identifier may have a different name, but it always represents the specific record to be retrieved or updated create records batch this activity allows you to create multiple records in sap business one in a single batch operation it supports high volume data creation with a maximum batch size of 1000 items, enabling efficient bulk processing object type – select the type of records to create, such as chart of accounts, orders, or sales opportunities the object type determines the structure and required fields for each record in the batch data list – specify or map a list of data items to define the records to be created each item in the list represents a record with its respective fields (e g , customer details, order items) after selecting a specific object, you will have the option to populate it’s fields by using “add field” add field by clicking the “add field” button, you can choose how to fill in the various fields in the record you are creating you can add one field to the activity or more fields to the activity definitions, up to the number of fields you have in the selected object the fields vary depending on the selected object choose from the drop down the field you want to fill click on the empty field to the right of the dropdown to see a tooltip with all the available options you can use to fill the field you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate delete records batch this activity allows you to delete multiple records from sap business one in a single operation this is useful for efficiently removing large amounts of data in bulk, with a maximum batch size of 1000 items object type – select the type of records you want to delete, such as chart of accounts, orders, or sales opportunities the object type defines the structure of the records being deleted data list – provide or map a list of identifiers (e g , account codes, document entries, sequential numbers) that specify which records to delete each item in the list corresponds to a record to be removed object id this field represents the unique identifier of the selected object record when an object is opened, each record has its own primary identifier the name of this identifier may vary depending on the object type for example, in the business partners object, the unique identifier is called card code for other objects, the identifier may have a different name, but it always represents the specific record to be retrieved or updated update records batch this activity allows you to update multiple records in sap business one in a single operation it supports high volume updates, making it efficient for modifying large datasets, with a maximum batch size of 1000 items object type – select the type of records you want to update, such as chart of accounts, orders, or sales opportunities the object type defines the structure of the records to be updated data list – provide or map a list of data items, where each item represents the record to be updated along with its new values each record in the list must include its unique identifier (e g , account code, document entry, or sequential number) and the fields to be updated after selecting a specific object, you will have the option to populate it’s fields by using “add field” add field by clicking the “add field” button, you can choose how to fill in the various fields in the record you are creating you can add one field to the activity or more fields to the activity definitions, up to the number of fields you have in the selected object the fields vary depending on the selected object choose from the drop down the field you want to fill click on the empty field to the right of the dropdown to see a tooltip with all the available options you can use to fill the field you can populate the field in one of the following options static value – number / string when using strings, you need to surround them with single quotes (‘) property value from a previous activity (using the tooltip that opens when clicking on the field) expression – using https //app archbee com/docs/ixqqblwfxopjg0nave78y/o3kkbgi5xnqf yvnuqkcv and/or previous activity properties and/or static values (using the tooltip that opens when clicking on the field) repeat steps 1 3 for all the fields you want to populate