Web services: searching and finding a lot of assets

umerckx

Hi everyone,

I have a java application that communicates with a mediabin repository trough the mediabin web services.

In this Java application we keep track of "products". Each of these products has an id: the "productId". Images of these products are kept in the mediabin repository, and we created a metadata attribute "product ID" in a new metadata group to be able to define to which product an image belongs.

We need to develop a report of a batch of products which, among other information, contains the names and some medata of the images that are stored in mediabin for each product. So it is not necessary to retrieve the whole image.

What is the most performant way to achieve this?
Writing a loop that searches assets for each product is slow: if we need to create a report of 1000 products, 1000 WS calls will need to be done.

I was hoping there is a way to specify: return metadata attribute X and Y for assets that hat a metadata attribute "product ID" that equals 123 or 345 or 346 or 347 or 9876.

Any suggestions?

Spiff

We need to develop a report of a batch of products which, among other information, contains the names and some medata of the images that are stored in mediabin for each product. So it is not necessary to retrieve the whole image.

You may try using the database report view ReportAssetMetaData. Suppose the identifiers of those "some metadata" are md1_id, md2_id, ..., and md3_id, then you may use the following SQL query to retrieve the asset data in one query:

SELECT * FROM ReportAssetMetaData
WHERE asset_id IN
(
SELECT amd.asset_id
FROM ReportAssetMetaData amd, MetaDataCatalog mdc
WHERE mdc.name = 'product ID'
AND amd.metadata_id = mdc.id
AND amd.metadata_value in ( '123', '345', '346', '347', '9876' )
)
AND metadata_id IN ( 'md1_id', 'md2_id', ..., 'mdn_id' )
ORDER BY asset_name