ScriptRunner Connect Managed API for Google Sheets

Managed API for Google Sheets is an API Client for Google Sheets by Adaptavist. You can read more about Managed APIs here.

This is ScriptRunner Connect runtime specific version of the Managed API (with sr-connect suffix). If you want to use Managed API in any other runtime, have a look at the runtime agnostic version.

Supported API calls

• fetch
• createSpreadsheet
• getSpreadsheet
• Value
  • appendValuesInRange
  • clearValuesInRange
  • getValuesInRange
  • setValuesInRange
• Sheet
  • copySheet

Constructing Managed API

In ScriptRunner Connect a Managed API is constructed for you, but if you need to construct it manually, here's how you can do it:

import { GoogleSheetsApi } from '@managed-api/google-sheets-v4-sr-connect';

export default async function() {
    const api = new GoogleSheetsApi('API_CONNECTION_ID');
}

Contact

Feel free to drop ideas, suggestions or improvements into our Slack community channel.

Changelog

• 2.0.0
  • Breaking change: URL and query string parameters are now URL encoded, meaning if you encoded them explicitly before you have to remove your own encoding, otherwise they will get double encoded.
• 0.1.6
  • Fixed README

Copyright Adaptavist 2022 (c) All rights reserved