Accessing Product Images From Excel Pinboards

There are a few pinboards that allow you to access the images for a product.

What is a pinboard?
Fieldpine supply an Excel addin that allows you to access realtime retail data using simple Excel formulas. The name of the function is "pinboard", which comes from the concept that an Excel formula can retrieve a single value, without needing to know how that value was derived. For example

=pinboard("sales.count.period")

Returns total number of sales so far today

=pinboard("sales.count.period", '1-jan-2023', '1-feb-2023')

Returns total number of sales for January 2023

=pinboard("product.description", 15)

Returns the current product description for product #15

Product Image Pinboards

"product imageurl"

Returns a complete URL to access the first image for a product. The first parameter is the image PID or Physkey

=pinboard("product imageurl", 153)
=pinboard("product imageurl", 'KEPHJRJBNSNRKJJS9KSMEK')

Note, there a space between the two words.

"product image count" or "product picture count"

Returns the number of images for a single product. The first parameter is either a PID or Physkey

=pinboard("product image count", 153)
=pinboard("product picture count", 'KEPHJRJBNSNRKJJS9KSMEK')

Note, there a space between each word. You may use either "image" or "picture" as the second parameter, they are interchangeable.

For more details, see Excel Product Images reference

Can Excel display the Image?

Yes. Recent version of excel offer the IMAGE() function. See Excel Product Images for more details and an example spreadsheet.

Other Ways to Access Images

Seperate to Excel, each image can be directly addressed with a standard URL naming scheme. Some examples

/Openapi/Product/153

Return the first known image for Pid=153

/Openapi/Product/153/2

Return the second known image for Pid=153

/Openapi/Product/KEPHJRJBNSNRKJJS9KSMEK/2

Return the second known image for product (physkey=KEPHJRJBNSNRKJJS9KSMEK)

/Openapi/Product/KEPHJRJBNSNRKJJS9KSMEK/abchdhejgh2gkjdj4i5hthv

Return the image for product (physkey=KEPHJRJBNSNRKJJS9KSMEK) where the image MD5 checksum is abchdhejgh2gkjdj4i5hthv. This is a complex format but ensures that you can address exactly a specific version. It is most commmonly used by eCommerce websites to retrieve exact images

There is also a "Media Dump" report at

/report/can/MediaDump.htm

This report lists all active media records with technical details such as size and MD5. If you mouse over a row, the corresponding image is displayed.