Read the metadata of the image assets in your accounts.

Table Specific Information

Select

For the AccountURN column, the = operator is fully supported server-side. The IN operator is partially supported server-side and partially client-side. Refer to the query examples below:

SELECT * FROM Images WHERE AccountURN = 'urn:li:sponsoredAccount:512859024';
SELECT * FROM Images WHERE AccountURN IN ('urn:li:sponsoredAccount:512859024', 'urn:li:sponsoredAccount:513009855')

For the URN column, the = operator is fully supported server-side. The IN operator is partially supported server-side and partially client-side. Refer to the query examples below:

SELECT * FROM Images WHERE URN = 'urn:li:image:D4D10AQHqn3iVssgwvA';
SELECT * FROM Images WHERE URN IN ('urn:li:image:D4D10AQHqn3iVssgwvA', 'urn:li:image:D4D10AQGGB-vB21hq4g')

For the two queries above, the values for the AccountURN, MediaLibraryName, and MediaLibraryStatus columns are not returned (always null).

When no criteria is specified as shown below:

SELECT * FROM Images;

, we internally post-process the query to the following before executing:

SELECT * FROM Images WHERE AccountURN IN (SELECT URN FROM Accounts);

The rest of the query is processed client-side.

Update

To modify an existing image, use an UPDATE statement. Note that the URN column and the AccountURN column are required in the WHERE clause.

The following columns are the ones that are mutable after creation:

• MediaLibraryName
• MediaLibraryStatus

UPDATE Images SET MediaLibraryName = 'My Test Image', MediaLibraryStatus = 'ARCHIVED' WHERE AccountURN = 'urn:li:sponsoredAccount:513009855' AND URN = 'urn:li:image:D4D10AQHqn3iVssgwvA'

Columns

Name	Type	ReadOnly	References	Description
URN [KEY]	String	True		The URN of the image.
AccountURN	String	True		The URN of the ad-account to which this image belongs.
MediaLibraryName	String	False		The name of the image asset in the media library.
MediaLibraryStatus	String	False		The status of the image asset in the media library. 使用できる値は次のとおりです。ACTIVE, ARCHIVED
OwnerURN	String	True		The URN of the entity who owns the image.
DownloadURL	String	True		The URL for downloading the image.
DownloadURLExpiresAt	Datetime	True		The time when the URL for downloading the image expires.
Status	String	True		The status of the image. 使用できる値は次のとおりです。PROCESSING, PROCESSING_FAILED, AVAILABLE, WAITING_UPLOAD