hobru/Simple OData Connect.EXCEL.yaml

## Simple OData Connect.EXCEL.yaml
name: Simple OData Connect
description: Calling a sample Service from OData.org
host: EXCEL
api_set: {}
script:
  content: |
    $("#run").click(() => tryCatch(getData));

    /** Default helper for invoking an action and handling errors. */
    async function tryCatch(callback) {
      try {
        await callback();
      } catch (error) {
        // Note: In a production add-in, you'd want to notify the user through your add-in's UI.
        console.error(error);
      }
    }

    async function getData() {
      const url = "https://services.odata.org/V4/(S(vlyeplehfrwjmggz5bkdsawe))/TripPinServiceRW/Airports";

      const myHeaders = new Headers();
      myHeaders.append("Content-Type", "application/json");

      const myInit = {
        method: "GET",
        headers: myHeaders
      };

      const myRequest = new Request(url, myInit);

      const response = await fetch(myRequest);

      //Expect that status code is in 200-299 range
      if (!response.ok) {
        throw new Error(response.statusText);
      }

      const jsonResponse = await response.json();
      console.log("REST call successful!");
      console.log("Response: " + jsonResponse.value[0].Name);

      await Excel.run(async (context) => {

        var Name = context.workbook.worksheets.getActiveWorksheet().getRange("D7");
        var IataCode = context.workbook.worksheets.getActiveWorksheet().getRange("D8");
        var LocationAdr = context.workbook.worksheets.getActiveWorksheet().getRange("D9");
        Name.values = jsonResponse.value[0].Name;
        IataCode.values = jsonResponse.value[0].IataCode;
        LocationAdr.values = jsonResponse.value[0].Location.Address;
      });

      return jsonResponse;
    }
  language: typescript
template:
  content: |
    <button id="run" class="ms-Button">
        <span class="ms-Button-label">Run</span>
    </button>
  language: html
style:
  content: |-
    section.samples {
        margin-top: 20px;
    }

    section.samples .ms-Button, section.setup .ms-Button {
        display: block;
        margin-bottom: 5px;
        margin-left: 20px;
        min-width: 80px;
    }
  language: css
libraries: |
  https://appsforoffice.microsoft.com/lib/1/hosted/office.js
  @types/office-js

  office-ui-fabric-js@1.4.0/dist/css/fabric.min.css
  office-ui-fabric-js@1.4.0/dist/css/fabric.components.min.css

  core-js@2.4.1/client/core.min.js
  @types/core-js

  jquery@3.1.1
  @types/jquery@3.3.1
	name: Simple OData Connect
	description: Calling a sample Service from OData.org
	host: EXCEL
	api_set: {}
	script:
	content: \|
	$("#run").click(() => tryCatch(getData));

	/** Default helper for invoking an action and handling errors. */
	async function tryCatch(callback) {
	try {
	await callback();
	} catch (error) {
	// Note: In a production add-in, you'd want to notify the user through your add-in's UI.
	console.error(error);
	}
	}

	async function getData() {
	const url = "https://services.odata.org/V4/(S(vlyeplehfrwjmggz5bkdsawe))/TripPinServiceRW/Airports";

	const myHeaders = new Headers();
	myHeaders.append("Content-Type", "application/json");

	const myInit = {
	method: "GET",
	headers: myHeaders
	};

	const myRequest = new Request(url, myInit);

	const response = await fetch(myRequest);

	//Expect that status code is in 200-299 range
	if (!response.ok) {
	throw new Error(response.statusText);
	}

	const jsonResponse = await response.json();
	console.log("REST call successful!");
	console.log("Response: " + jsonResponse.value[0].Name);

	await Excel.run(async (context) => {

	var Name = context.workbook.worksheets.getActiveWorksheet().getRange("D7");
	var IataCode = context.workbook.worksheets.getActiveWorksheet().getRange("D8");
	var LocationAdr = context.workbook.worksheets.getActiveWorksheet().getRange("D9");
	Name.values = jsonResponse.value[0].Name;
	IataCode.values = jsonResponse.value[0].IataCode;
	LocationAdr.values = jsonResponse.value[0].Location.Address;
	});

	return jsonResponse;
	}
	language: typescript
	template:
	content: \|
	<button id="run" class="ms-Button">
	<span class="ms-Button-label">Run</span>
	</button>
	language: html
	style:
	content: \|-
	section.samples {
	margin-top: 20px;
	}

	section.samples .ms-Button, section.setup .ms-Button {
	display: block;
	margin-bottom: 5px;
	margin-left: 20px;
	min-width: 80px;
	}
	language: css
	libraries: \|
	https://appsforoffice.microsoft.com/lib/1/hosted/office.js
	@types/office-js

	office-ui-fabric-js@1.4.0/dist/css/fabric.min.css
	office-ui-fabric-js@1.4.0/dist/css/fabric.components.min.css

	core-js@2.4.1/client/core.min.js
	@types/core-js

	jquery@3.1.1
	@types/jquery@3.3.1