Google BigQuery and Softr Integration

How does the integration between Google BigQuery and Softr work in WEXTL?

WEXTL exposes actions and triggers for Google BigQuery and Softr that help you connect apps and automate repetitive tasks [1]. A trigger is an event that happens, an action — a step that performs when the event has occurred.

Google BigQuery triggersSoftr actions

Swap apps

Google BigQuery modules

• 
  Cancel JobCancels a running job.
• 
  Create DatasetCreates a new dataset.
• 
  Create JobCreates a query, load, copy, or extract job.
• 
  Create RoutineCreates a new routine.
• 
  Create Row Access PolicyCreates a row access policy.
• 
  Create TableCreates a new table.
• 
  Delete DatasetDeletes a dataset.
• 
  Delete JobDeletes the metadata of a completed job.
• 
  Delete ModelDeletes a model.
• 
  Delete RoutineDeletes a routine.
• 
  Delete Row Access Policies in BatchDeletes several row access policies.
• 
  Delete Row Access PolicyDeletes a row access policy.
• 
  Delete TableDeletes a table.
• 
  Edit DatasetUpdates selected fields on a dataset.
• 
  Edit ModelUpdates selected fields on a model.
• 
  Edit TableUpdates selected fields on a table.
• 
  Execute QueryRuns a SQL query.
• 
  Get DatasetReturns a single dataset.
• 
  Get JobReturns a single job.
• 
  Get ModelReturns a single model.
• 
  Get Query ResultsReturns results for a query job.
• 
  Get RoutineReturns a single routine.
• 
  Get Routine IAM PolicyReturns the IAM policy for a routine.
• 
  Get Row Access PolicyReturns a single row access policy.
• 
  Get Row Access Policy IAM PolicyReturns the IAM policy for a row access policy.
• 
  Get Service AccountReturns the project's BigQuery service account.
• 
  Get TableReturns a single table.
• 
  Get Table IAM PolicyReturns the IAM policy for a table.
• 
  Insert RowsInserts rows into a table.
• 
  List DatasetsRetrieves datasets in a project.
• 
  List JobsRetrieves jobs in a project.
• 
  List ModelsRetrieves models in a dataset.
• 
  List ProjectsRetrieves projects the user can access.
• 
  List RoutinesRetrieves routines in a dataset.
• 
  List Row Access PoliciesRetrieves row access policies on a table.
• 
  List Table DataRetrieves rows from a table.
• 
  List TablesRetrieves tables in a dataset.
• 
  Make an API CallPerforms an arbitrary authorized API call.
• 
  Set Routine IAM PolicySets the IAM policy for a routine.
• 
  Set Table IAM PolicySets the IAM policy for a table.
• 
  Test Routine IAM PermissionsTests IAM permissions on a routine.
• 
  Test Row Access Policy IAM PermissionsTests IAM permissions on a row access policy.
• 
  Test Table IAM PermissionsTests IAM permissions on a table.
• 
  Undelete DatasetRestores a recently deleted dataset.
• 
  Update DatasetReplaces an existing dataset.
• 
  Update RoutineReplaces an existing routine.
• 
  Update Row Access PolicyReplaces a row access policy.
• 
  Update TableReplaces an existing table.
• 
  Watch JobsTriggers when a new BigQuery job is created.

Softr modules

• 
  Add Table FieldAdds a new field to a table.
• 
  Create a DatabaseCreates a new database in your Softr workspace.
• 
  Create RecordCreates a new record in a table.
• 
  Create TableCreates a new table in a database.
• 
  Create UserCreates a new end user for your published Softr app.
• 
  Delete DatabaseDeletes a database from your Softr workspace.
• 
  Delete RecordDeletes a record from a table.
• 
  Delete TableDeletes a table from a database.
• 
  Delete Table FieldDeletes a field from a table.
• 
  Delete UserDeletes an end user from your published Softr app.
• 
  Generate Magic Link for UserGenerates a one-time magic sign-in link for an end user.
• 
  Get DatabasesRetrieves a list of databases in your Softr workspace.
• 
  Get RecordsRetrieves a list of records from a table.
• 
  Get Single DatabaseReturns a single database by ID.
• 
  Get Single RecordReturns a single record by ID.
• 
  Get Single TableReturns a single table by ID.
• 
  Get Table FieldReturns a single table field by ID.
• 
  Get TablesRetrieves a list of tables in a database.
• 
  Get Table ViewsRetrieves a list of views defined on a table.
• 
  Invite UserSends an invitation email to an end user of your Softr app.
• 
  Make an API CallPerforms an arbitrary authorized API call.
• 
  Search RecordsSearches records in a table using filter and sort conditions.
• 
  Set User ActiveReactivates a deactivated end user of your Softr app.
• 
  Set User InactiveDeactivates an end user of your Softr app.
• 
  Sync UsersSynchronizes end user records for your published Softr app.
• 
  Update DatabaseUpdates the name or description of a database.
• 
  Update RecordUpdates the field values of a record.
• 
  Update TableUpdates the name or description of a table.
• 
  Update Table FieldUpdates the name, type, or options of a table field.
• 
  Validate Auth TokenValidates a user authentication token for your published Softr app.
• 
  Watch RecordsTriggers when a record's date field is new or updated.