1. Automate
2. Documentation
3. Content query

Content query

An action block that queries content provided by another app, such as contacts or calendar events.

The fiber will pause until the content has been retrieved.

The column result types control how integer and float column values are returned, choose Bigint for accurate 64-bit integer results when necessary. Binary (blob) columns are not supported and therefor excluded from the result.

Common content URIs

• content://call_log/calls — call log, see Android documentation.
• content://com.android.calendar/events — calendar events, see Android documentation.
• content://com.android.contacts/contacts — contacts, see Android documentation.
• content://mms — all MMS, see Android documentation.
• content://mms/inbox — unread received MMS, see Android documentation.
• content://mms/sent — sent MMS, see Android documentation.
• content://settings/global — system settings in Global category, see Android documentation.
• content://settings/secure — system settings in Secure category, see Android documentation.
• content://settings/system — system settings in System category, see Android documentation.
• content://sms — all SMS, see Android documentation.
• content://sms/inbox — unread received SMS, see Android documentation.
• content://sms/sent — sent SMS, see Android documentation.

Result types

• Rows as arrays — an array of rows where each row element is an array with column values.
• Rows as dictionaries — an array of rows where each row element is a dictionary with column names as keys and the value thereof.
• Concatenated rows — a single “flat” array with all column values of all rows concatenated.

Input arguments

• Content URI — URI of content to query.
• Columns — a comma separated list or array of columns to include in the result, default is all.
• Where clause — an SQL WHERE clause for matching a sub-selection of the content identified by Content URI, default is all content.
• Parameters — an array of values to replace any ? within the Where clause.
• Order by — the sort order of the result, default is no order.
• Offset — the offset of the first row to include in the result, default 0.
• Limit — the maximum number of rows in the result, default is 500 (the maximum limit).
• Result type — type of result assigned to result see result types, default is Rows as arrays.
• Column result types — value type of integer and float columns in result, default is Default.

Output variables

• Result — variable to assign an array with the query result, structured as result type with integer and float as column result type.