XLConnect
  • XLConnect Documentation
  • Using XLConnect
    • Getting Started
    • Using XLConnect
    • Manage Users
    • Manage Your Subscription (Owners)
    • XLConnect Security
    • Troubleshooting
  • Developing with XLConnect
    • Getting Started
    • The Bigger Picture
    • Import Scripts
    • Scripts
    • Cloud Systems
    • Javascript
      • Javascript Studio
      • Javascript language
      • Calling API's with HTTP Requests
      • Working with JSON data
      • The xlc object
      • Advanced Javascript
    • Modules
      • HTTP module
      • FILE module
    • Maps
    • JSON Data Format
    • Data Lake
    • Excel modelling
    • VBA
    • The XLConnect API
  • Reference
    • Change log
Powered by GitBook
On this page
  • Xero
  • Visma.Net Native
  • Visma Client Credentials (Service)
  • Exact Online
  • QuickBooks Online
  • Payhawk
  • Hubspot
  • Microsoft Graph
  • Microsoft Dynamics 365
  • Basic Authentication
  • NMBRS
  1. Developing with XLConnect

Cloud Systems

List of cloud systems

PreviousScriptsNextJavascript

Last updated 1 year ago

XLConnect comes 'batteries included' with authentication to cloud systems built in, so you can get straight to the business logic.

When making calls, the final parameter is auth to indicate the cloud system you want to authenticate to.

Below is a simple example of a direct http call, please note that these cloud systems also have a with helper methods.

http = require('http.js')

// grab data from the xero api
uri = 'https://api.xero.com/connections'
auth = 'xero'
http.get(uri, null, auth)

// or shorthand 
http.get('https://api.xero.com/connections', null, 'xero')

Xero

auth = 'xero'

Visma.Net Native

auth = 'visma.net'

Use this authentication for the and the .

This uses the Authentication Code Interactive flow that automatically open a web browser to log the user in and return to the app.

Visma Client Credentials (Service)

auth = 'vismacc'

Exact Online

auth = 'exact'

QuickBooks Online

auth = 'qbo'

Payhawk

auth = 'payhawk'

Hubspot

auth = 'hubspot'

Microsoft Graph

auth = 'ms.graph'

Microsoft Dynamics 365

auth = 'ms.dynamics'

Basic Authentication

auth = 'basic'

NMBRS

auth = 'nmbrs'

Services Visma API's like use a Service (Client Credentials flow) authentication.

Please note these need to be set up per project in the .

API description here:

HTTP
javascript module
Visma.Net API
Visma.net.ERP.SalesOrders.Api
Brincr
Visma Developer Portal
https://start.exactonline.nl/docs/HlpRestAPIResources.aspx?SourceAction=10
https://developers.payhawk.com/
https://developers.hubspot.com/docs/api/crm/understanding-the-crm