@easyapis/easyapis-excelonlinebusiness NPM

An isomorphic javascript sdk for - ExcelonlinebusinessConnector

This package contains an isomorphic SDK for ExcelonlinebusinessConnector.

Currently supported environments

Node.js version 6.x.x or higher
Browser JavaScript

How to Install

npm install @easyapis/easyapis-excelonlinebusiness

How to use

nodejs - Authentication, client creation and getTables as an example written in TypeScript.

Install @azure/ms-rest-nodeauth

Please install minimum version of "@azure/ms-rest-nodeauth": "^3.0.0".

npm install @azure/ms-rest-nodeauth@"^3.0.0"

Sample code

import * as msRest from "@azure/ms-rest-js";
import * as msRestNodeAuth from "@azure/ms-rest-nodeauth";
import { ExcelonlinebusinessConnector, ExcelonlinebusinessConnectorModels, ExcelonlinebusinessConnectorMappers } from "@easyapis/easyapis-excelonlinebusiness";
const subscriptionId = process.env["AZURE_SUBSCRIPTION_ID"];

msRestNodeAuth.interactiveLogin().then((creds) => {
  const client = new ExcelonlinebusinessConnector(creds, subscriptionId);
  const source = "testsource";
  const drive = "testdrive";
  const file = "testfile";
  const select = "testselect";
  client.getTables(source, drive, file, select).then((result) => {
    console.log("The result is:");
    console.log(result);
  });
}).catch((err) => {
  console.error(err);
});

browser - Authentication, client creation and getTables as an example written in JavaScript.

Install @azure/ms-rest-browserauth

npm install @azure/ms-rest-browserauth

Sample code

See https://github.com/Azure/ms-rest-browserauth to learn how to authenticate to Azure in the browser.

index.html

<!DOCTYPE html>
<html lang="en">
  <head>
    <title>@easyapis/easyapis-excelonlinebusiness sample</title>
    <script src="node_modules/@azure/ms-rest-js/dist/msRest.browser.js"></script>
    <script src="node_modules/@azure/ms-rest-browserauth/dist/msAuth.js"></script>
    <script src="node_modules/@easyapis/easyapis-excelonlinebusiness/dist/easyapis-excelonlinebusiness.js"></script>
    <script type="text/javascript">
      const subscriptionId = "<Subscription_Id>";
      const authManager = new msAuth.AuthManager({
        clientId: "<client id for your Azure AD app>",
        tenant: "<optional tenant for your organization>"
      });
      authManager.finalizeLogin().then((res) => {
        if (!res.isLoggedIn) {
          // may cause redirects
          authManager.login();
        }
        const client = new Easyapis.EasyapisExcelonlinebusiness.ExcelonlinebusinessConnector(res.creds, subscriptionId);
        const source = "testsource";
        const drive = "testdrive";
        const file = "testfile";
        const select = "testselect";
        client.getTables(source, drive, file, select).then((result) => {
          console.log("The result is:");
          console.log(result);
        }).catch((err) => {
          console.log("An error occurred:");
          console.error(err);
        });
      });
    </script>
  </head>
  <body></body>
</html>

Related projects

Microsoft Azure SDK for Javascript

Impressions

node azure typescript browser isomorphic

@azure/identity @azure/ms-rest-js tslib

@easyapis/easyapis-all @everything-registry/sub-chunk-273 @infinitebrahmanuniverse/nolb-_ea @zalastax/nolb-_ea

0.0.2-alpha

4 years ago

0.0.1-alpha

4 years ago