SierraFunctions class implements functions to make Sierra Apis call using Excel-DNA
Clone repo in VS2019 and change base_url and header_basic_auth in SierraFunctions class according to SIERRA API Documentation then build.
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.
- About()
- GetToken()
- Barcode2Id()
- Barcode2Name()
- Barcode2Email()
- Barcode2PatronType()
- Barcode2MoneyOwed()
- Barcode2CheckoutItems()
- Item2BibId()
- BibId2Title()
Returns author information.
Sample usage: =About()
Returns token.
Sample usage: =GetToken()
Sample output in Postman
{
"access_token": "v0Qvd3EscNjMPF9zH606RebLuOaVrTuG6Bs9Vf1_cPFxRKCJPWSbTPOlTOi-bLF17Hcl-8-A2UdTvyMhZfIDATYKLgnh5y_02xNqYq9PGIQ",
"token_type": "bearer",
"expires_in": 3600
}
Returns patron id by barcode.
Sample usage: = Barcode2Id("1845")
Returns patron name by barcode.
Sample usage: =Barcode2Name("1845")
Returns patron e-mail by barcode.
Sample usage: =Barcode2Email("1845")
Returns patron type by barcode.
Sample usage: =Barcode2PatronType("1845")
Returns patron money owed by barcode.
Sample usage: =Barcode2MoneyOwed("1845")
Returns checkout items by barcode.
Sample usage: =Barcode2CheckoutItems("1845")
Returns bib id by item.
Sample usage: =Item2BibId("1136526")
Returns title by bib id.
Sample usage: =BibId2Title("1159654")
Copyright (c) Gokay Gursoy. All rights reserved.
Licensed under the MIT License.
Free Software
Made with ❤ in Turkey