Content Questions

[Patrick Corgan]

I am trying to use the "When content changed" block to determine if another fiber has been started. In the 'Content URI' field I put:
"content://com.llamalab.automate.provider/fibers"
And the flow doesn't continue when I start a new fiber. If I use
"content://com.llamalab.automate.provider/flows"
the flow does continue when I start a new fiber, but it also continues on other flow-related events that I want to ignore. Is there an event that is triggered just by the creation of a new fiber?

Also, is there a way to exclude a specific column from the "Query content" block? I'd like to get a list of columns from a provider, but the "data" column crashes my flow because blob columns are not supported.

[Henrik "The Developer" Lindqvist]

Fibers are not notified for change, since that happens a lot possible cause performance issues. Flows do since that only happens when the user edits a flow.

There's no way for a flow to monitor fibers, except implementing nit yourself, maybe using a custom broadcast.

Just write the columns you want in the result, in the Columns field.

[Patrick Corgan]

Thank you Henrik. Is there a way to get a list of valid columns? I'm curious and I want to see what is possible. I'd like to know what content Automate provides and how to access it.

[El Cid]

You can get the columns by content query and output as dictioary, the dictionary keys will be the column names.

[Patrick Corgan]

That doesn't work when there is a blob column :( That is my reason for this post.

[El Cid]

CREATE TABLE flows (
_id integer primary key autoincrement,
version integer not null default 1,
title text,
description text,
logging integer, -- version 4
channel_id text, -- version 7
community_id integer,
downloaded integer,
statements integer not null default 0, -- version 2
data blob not null
)

using https://play.google.com/store/apps/details?id=dk.andsen.asqlitemanager

[Henrik "The Developer" Lindqvist]

Currently not possible, if it includes a blob column. You need to read the documentation for the app to query.

There's no official support for querying flows, but the columns are: _id, name, description, version, logging, channel_id, community_id, fiber_count, statements, downloaded

[Patrick Corgan]

Awesome! Thank you both!