Quickbooks

learn how to connect quickbooks to engini, enabling efficient integration of your accounting and financial management processes with the quickbooks connector, you can access real time financial data, automate tasks like invoice processing, customer record management, and financial reporting, and enhance operational efficiency connecting engini to quickbooks enter your engini account at https //app engini io https //app engini io/ navigate to connections page by clicking on the connections on the left side bar or by clicking here https //app engini io/connections click on the "new integration" option located at the top bar choose “quickbooks” option from available applications enter the following details in the “new integration” form and press save connection name a unique identifier for the connection within engini authentication method – select the authentication method used to connect to your quickbooks account in most cases, oauth2 is used, allowing you to securely authorize engini without entering your quickbooks credentials directly url after logging into your account, your url will appear automatically on the screen in engini environment select the appropriate environment from the dropdown list sandbox – for testing production – for live data signin when you click on ‘signin’, the following window appears fill in your login details save settings after signing in, click save to finalize and store the connection activities create record this activity creates a new record in quickbooks based on the selected object type object type – select the type of quickbooks object you want to create (e g , customer, invoice, item) the available options depend on the integration capabilities and the specific data model supported by quickbooks after selecting the object type (e g , accounts ), provide the necessary detail name – enter the name of the account you want to create accounttype – select the type of account (e g , bank, credit card, expense) this defines how the account will behave in the system add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields delete record this activity deletes an existing record from quickbooks based on the specified object type and record id object type – you can choose from the following objects to delete a record bill, payment, or invoice id – enter the unique identifier of the record you want to delete this value must match an existing record in quickbooks after selecting the object type (e g , bill ), provide the necessary detail vendor’s id – enter the unique identifier of the vendor associated with the bill you want to delete add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields get record this activity retrieves a specific record from quickbooks using its object type and record id use this when you need to access detailed information about a particular record for use later in your workflow object type – select the type of quickbooks object you want to retrieve (e g , customer, invoice, item) record id – enter the unique identifier of the record you want to fetch the retrieved data can be used in subsequent steps get records this activity retrieves multiple records of a specific object type from quickbooks object type – select the type of object you want to retrieve records from top n – you can specify how many records with the same value you want to get click on ‘top n’ and enter the maximum number of values you want to retrieve if you set top n = 1 , a single record will be returned instead of an array if no record is found, the action will fail, allowing you to implement an if condition within the workflow this can be useful for processes where the existence of a record determines the next steps in the workflow add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add sort click add sort to organize the data list by a selected field in ascending or descending order to learn more about sorting data, click here https //help engini ai/workflow editor#add sorts initialize objects variable this activity initializes a new variable designed to hold an array of objects of a specific quickbooks type variable name – enter a name for the variable that will store the array of objects object element type – select the type of object that this variable will contain (e g , invoice, payment, bill) this determines the structure and available fields for each item in the list add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields append object to array this action adds a new object to an existing object array variable that was initialized earlier in the workflow variable – select the array you initialized in the previous steps add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields map array this activity transforms a list of data into an array of quickbooks compatible objects data list – select the list of items you want to transform this can be a variable or output from a previous step object element type – select the type of object that each item in the list represents this defines the structure and available fields for each item during the mapping process after selecting a specific object, you will have the option to populate it’s fields by using “add field” add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields update record this activity updates an existing record in quickbooks based on its object type and id use this to make changes to specific fields of a record, such as updating customer information, modifying an invoice, or editing item details object type – select the type of quickbooks object you want to update (e g , customer, invoice, item) id – enter the unique identifier of the record you want to update after selecting the action type (e g , send email), provide the necessary details for the action name – the field refers to the new name you want to assign to the selected account record add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields update category this activity updates an existing category record in quickbooks use this to modify the details of a category, such as its name, description, or other fields, based on your workflow requirements add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields send api request this activity allows you to send a custom api request directly to the quickbooks api base url – this is the root url of the api you’re sending the request to relative url – you can specify additional path segments or parameters that need to be added to the end of the automatically generated url this allows you to customize the specific request you want to perform method – select the http method (e g , get, post, put, delete, patch) body type – defines the format of the data in the body of your request commonly used values include application/json (as shown), which means the body will contain a json formatted payload body – contains any data that is being sent to the server add headers – additional metadata about the request, such as the type of data the engini can accept, the length of the request body, and authentication information add queries – the query refers to the parameters or data that are included in the url of an http request to provide additional information or instructions to the server