Get all items from an exhibit via API

[westcoast509]

Is there a way to get all items used in a specific exhibit through the api? Something like:

domain/api/exhibits/id/items?pretty-print

(which just returns the info about the exhibit as if “items” wasn’t included)

OR

Given an item, how can I tell where it’s used on an Omeka site?

I have access to the SQL databases, so can look there as well with a little guidance.

[jflatnes]

There’s an ?exhibit=<exhibit id> GET parameter for browsing items that gets you the items attached to a given exhibit… but this isn’t exposed in the API.

On the SQL side, it’s a multi-level join: the exhibit_block_attachments table records which items are used in each block, exhibit_page_blocks links blocks to their parent pages, and exhibit_pages links each page to its exhibit.

[westcoast509]

Thanks! I was able to get the info I needed through your tips of where to look in the database!