getLastAttachmentByRecordId

Retrieves the most recent attachment for a given record ID as a blob.

This function queries the database to find the latest attachment associated with a specific record ID. If the documentTypeId is 0, the document type filter is ignored.

Parameters

• tableName: string

  • The name of the table where the record is stored.

• recordId: number

  • The ID of the record for which the attachment is being retrieved.

• documentTypeId: number

  • The ID of the document type to filter by. If 0 or null, this filter is ignored.

Returns

• Promise<Blob>

  • A promise that resolves to a blob containing the attachment, or null if no attachment is found.

Example

  try {
    // Retrieve the last attachment for a record with ID 123 in the 'Orders' table, ignoring document type filter
    const blob = app.getLastAttachmentByRecordId('Orders', 123, 0);
    if (blob) {
      app.printBlob(blob);
    } else {
      console.log('No attachment found for the given record ID.');
    }
  } catch (error) {
    console.error('Error retrieving attachment:', error);
  }