Microsoft is a software corporation that develops, manufactures, licenses, supports, and sells a range of software products and services.
|Platform||Microsoft Dynamics Business Central|
See the table below for the list of data you can read with the Microsoft Dynamics Business Central connector.
id, systemVersion, name, displayName, businessProfileId, systemCreatedAt, systemCreatedBy, systemModifiedAt, systemModifiedBy
id, displayName, addressLine1, addressLine2, city, state, country, postalCode, phoneNumber, faxNumber, email, website, taxRegistrationNumber, currencyCode, currentFiscalYearStartDate, industry, [email protected], lastModifiedDateTime
id, number, displayName, type, itemCategoryId, itemCategoryCode, blocked, gtin, inventory, unitPrice, priceIncludesTax, unitCost, taxGroupId, taxGroupCode, baseUnitOfMeasureId, baseUnitOfMeasureCode, generalProductPostingGroupId, generalProductPostingGroupCode, inventoryPostingGroupId, inventoryPostingGroupCode, lastModifiedDateTime, picture, itemCategory
id, number, invoiceDate, postingDate, dueDate, vendorInvoiceNumber, vendorId, vendorNumber, vendorName, payToName, payToContact, payToVendorId, payToVendorNumber, shipToName, shipToContact, buyFromAddressLine1, buyFromAddressLine2, buyFromCity, buyFromCountry, buyFromState, buyFromPostCode, shipToAddressLine1, shipToAddressLine2, shipToCity, shipToCountry, shipToState, shipToPostCode, payToAddressLine1, payToAddressLine2, payToCity, payToCountry, payToState, payToPostCode, shortcutDimension1Code, shortcutDimension2Code, currencyId, currencyCode, orderId, orderNumber, pricesIncludeTax, discountAmount, discountAppliedBeforeTax, totalAmountExcludingTax, totalTaxAmount, totalAmountIncludingTax, status, lastModifiedDateTime, purchaseInvoiceLines
id, number, externalDocumentNumber, invoiceDate, postingDate, dueDate, customerPurchaseOrderReference, customerId, customerNumber, customerName, billToName, billToCustomerId, billToCustomerNumber, shipToName, shipToContact, sellToAddressLine1, sellToAddressLine2, sellToCity, sellToCountry, sellToState, sellToPostCode, billToAddressLine1, billToAddressLine2, billToCity, billToCountry, billToState, billToPostCode, shipToAddressLine1, shipToAddressLine2, shipToCity, shipToCountry, shipToState, shipToPostCode, currencyId, shortcutDimension1Code, shortcutDimension2Code, currencyCode, orderId, orderNumber, paymentTermsId, shipmentMethodId, salesperson, pricesIncludeTax, remainingAmount, discountAmount, discountAppliedBeforeTax, totalAmountExcludingTax, totalTaxAmount, totalAmountIncludingTax, status, lastModifiedDateTime, phoneNumber, email, salesInvoiceLines
vendorId, vendorNumber, name, totalPurchaseAmount, dateFilter_FilterOnly
id, number, displayName, addressLine1, addressLine2, city, state, country, postalCode, phoneNumber, email, website, taxRegistrationNumber, currencyId, currencyCode, irs1099Code, paymentTermsId, paymentMethodId, taxLiable, blocked, balance, lastModifiedDateTime
Follow the steps below to get the credentials you need to use the Microsoft Dynamics Business Central connector.
The first thing that you need to do to get your Microsoft Dynamics Business Central credentials is to login to your Microsoft Dynamics Business Central dashboard. If you do not have a Microsoft Dynamics Business Central account, you can create learn how to create one here.
Once in your Microsoft Dynamics Business Central dashboard. The first thing you will need is to grab your Environment ID for Microsoft Dynamics. You can do that by looking the URL of the page and grabbing the highlighted section above. The URL is constructed as
Next, you should click the Settings icon in the top right hand corner of the page.
From the resulting dropdown, select the Advanced settings option.
From the pop-up window, click on the Manual Setup option.
Then this page will appear. Make sure you head to the User permissions section and click on it.
You will now be on the Users page. Go ahead and click on the User you want to have hotglue connect to. For example, I will go ahead and connect the DAVID user so I will click on the DAVID User Name.
You now have your API Username as the first entry in the General section (in this case it would be DAVID). Now to get the Access Key, triple click on the access key to copy it. Paste this into hotglue and you are all set!
Updated 4 months ago