README.md

SierraLibrary

About

SierraFunctions class implements functions to make Sierra Apis call using Excel-DNA

Build

Clone repo in VS2019 and change base_url and header_basic_auth in SierraFunctions class according to SIERRA API Documentation then build.

Installation

Open Excel then click on Developer tab and click Excel Add-ins button. Click Browse... button. Select SierraLibrary-AddIn.xll file in SierraLibrary\bin\Release directory.

After install Excel Add-ins you can see all implemented functions in sierra category.

Functions

• About()
• GetToken()
• Barcode2Id()
• Barcode2Name()
• Barcode2Email()
• Barcode2PatronType()
• Barcode2MoneyOwed()
• Barcode2CheckoutItems()
• Item2BibId()
• BibId2Title()

About()

Returns author information.

Sample usage: =About()

GetToken()

Returns token.

Sample usage: =GetToken()

Sample output in Postman

		 {
		   "access_token": "v0Qvd3EscNjMPF9zH606RebLuOaVrTuG6Bs9Vf1_cPFxRKCJPWSbTPOlTOi-bLF17Hcl-8-A2UdTvyMhZfIDATYKLgnh5y_02xNqYq9PGIQ",
		   "token_type": "bearer",
		   "expires_in": 3600
		 }

Barcode2Id()

Returns patron id by barcode.

Sample usage: = Barcode2Id("1845")

Barcode2Name()

Returns patron name by barcode.

Sample usage: =Barcode2Name("1845")

Barcode2Email()

Returns patron e-mail by barcode.

Sample usage: =Barcode2Email("1845")

Barcode2PatronType()

Returns patron type by barcode.

Sample usage: =Barcode2PatronType("1845")

Barcode2MoneyOwed()

Returns patron money owed by barcode.

Sample usage: =Barcode2MoneyOwed("1845")

Barcode2CheckoutItems()

Returns checkout items by barcode.

Sample usage: =Barcode2CheckoutItems("1845")

Item2BibId()

Returns bib id by item.

Sample usage: =Item2BibId("1136526")

BibId2Title()

Returns title by bib id.

Sample usage: =BibId2Title("1159654")

License

Copyright (c) Gyokay Nurvet Mustafa. All rights reserved.

Licensed under the MIT License.

Free Software

Made with ❤ in Turkey