Fetching Book Cover Images and Related Data into Business Central

•PDG wrote a custom program (built into Business Central) to import a long list of ISBN's into Business Central via Excel, pass them to the ISBN database API, and return a list of data associated with that list, such as:

•Title

•Publisher

•Author

•MSRP

•Cover Image

•Binding (format)

•The setup for that program is in the Purchases Payables Setup Screen. Image attached. It contains the URL to access the ISBN dB API both for GET and POST commands.

•GET asks for one record at a time and is slower than POST, which can process multiple records.

•For instance, retrieving information for a list of 1000 ISBNs takes 12 minutes using the GET command and less than a minute using the POST command.

•In order to use the API, you need the URL to find it and the Authorization Key to authenticate you. Both are stored in the Purchase & Payables Setup in Business Central. A picture of that setup screen is shown on the next slide.

•The Purchases & Payables Setup window has the 3 custom fields we added to hold the information so you can fetch book data from the ISBN database.

•You need the addresses of the ISBN Database. (One URL for GET Requests and one URL for POST Requests.)

•You need an Authorization Key to show that you have paid your monthly premium for the subscription to the ISBN Database.

Here is a slide from Business Central where our developer has added a Menu Action to start the process to import a simple Excel file of 13-Digit ISBN's (International Standard Book Number).

This is a slide of the last list of ISBN's that were previously processed. Delete it and import the next list.

After deleting the prior list, now import a new list of ISBN's from Excel. Clicking on the "Import ISBN Excel" button will ask you to specify the import file.

Here is a list of ISBN's from the customer's purchase order. These books needed to be entered into the Business Central Item Table (the Item Card). These items may or may not already be in the Item Card List (inventory). Once we acquire all the relevant information from our subscription to the online ISBN Database (Publisher, Book Cover image, Category, Book Format, Author, etc.), then we will use Smart Connect to upload the new titles into our Inventory.

We will take Column E and copy that column to a second tab, which our embedded Business Central App will pass to the ISBN dB to fill in related information: Title, Author, Publisher, MSRP, Category, Cover Image URL, format,etc.

Once I copied the ISBN column onto a separate Excel tab, I go back to the Business Central menu and run the UPDATE action. This action will import the Excel list of ISBN's into Business Central so our App can then send them to the ISBN dB API to fetch related information: Title, Author, Publisher, MSRP, Category, Format, etc.

Next step is to send these 970 ISBN's to ISBN dB API to fetch related information: Title, Author, Publisher, MSRP, Category, Format, etc. Use the POST Method from our App within BC. The POST command sends the entire list at once. The GET command is much slower because it sends one ISBN Request at a time. That said, there are times when you have to use GET because of high Internet traffic and POST misses a few. GET is more reliable, but takes 10 times as long.

After the 970 Requests were sent the Request Data column below gets filled in. Now press the ISBN Response Staging List button to see the returned information.