REST access to blister functions

To take the idea covered in Getting lists as a restquery a little further, why not simple expose all the custom blister functions so they can be queried too. This means that you can use exactly the same lists, and have the same lookup, filtering and sorting capability as from the custom functions in GAS.

The Google Script API URL 

https://script.google.com/macros/s/AKfycbzBskBK17poScDU9yHnfgmgPHyvgNejM3zxV7niGdhLeXPjw7Y4/exec

Parameters

These are passed on the URL as usual. Remember that everything is case sensitive, and not all functions need all parameters.

 parameter  usage
 func  the name of any custom blister functions. For example, func=blisterData
 listName  the name of the list to get the data for. For example, listName=blister.airlines
 sortId  the listId to sort on, for example, sortId=carrier
 sortDescending  whether to sort descending or not
 listId  the listId to select, for example, listId=name
 idx  the position of the item, for example, idx=20
 value  the value to lookup, for example value=UA
 returnListId  the listId of the data to return, for example, returnListId=name
 library  the name of the library to directory, for example, library=blister
 filters  the list of filterIDs and filterValue pairs to apply, separated by commas, for example, filters=carrier,UA

Examples

[["currencies","List of currencies and exchange rates by country and ISO code"],["languageCodes","list of language codes by country"],["champagne","volume of champagne shipped"],["billboardhot100","billboard top 100"],["airlines","list of airlines and their flight codes"]]
https://script.google.com/macros/s/AKfycbzBskBK17poScDU9yHnfgmgPHyvgNejM3zxV7niGdhLeXPjw7Y4/exec?func=blisterList&listName=blister.airlines&listId=carrier&maxMatch=10
[["2F"],["2J"],["2N"],["3M"],["3X"],["4Z"],["5T"],["6E"],["7D"],["7F"]]
Try some of the examples in Using blister custom functions as these type of rest queries.


The Code

is fairly trivial - all we are doing is calling existing functions



All comments, suggestions, assistance, good lists are welcome as I develop this capability. You can get me on Google plus, Twitter or this forum.


For help and more information join our forum,follow the blog or follow me on twitter .

Comments