Google BigQuery and NocoDB Integration

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

WEXTL exposes actions and triggers for Google BigQuery and NocoDB 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 triggersNocoDB actions

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.

NocoDB modules

• 
  Add SortAdds a sort rule to a NocoDB view.
• 
  Count Table RecordsReturns the count of records in a NocoDB table, with optional filter.
• 
  Create BaseCreates a new base in a NocoDB workspace.
• 
  Create DocumentCreates a new document in a NocoDB base.
• 
  Create FieldAdds a new field (column) to a NocoDB table.
• 
  Create FilterAdds a filter condition to a NocoDB view.
• 
  Create TableCreates a new table in a NocoDB base.
• 
  Create Table RecordsCreates one or more records in a NocoDB table.
• 
  Delete BaseDeletes a NocoDB base permanently.
• 
  Delete Base UsersRemoves users from a NocoDB base.
• 
  Delete DocumentDeletes a document from a NocoDB base.
• 
  Delete FieldDeletes a field from a NocoDB base permanently.
• 
  Delete FilterRemoves a filter from a NocoDB view.
• 
  Delete SortRemoves a sort rule from a NocoDB view.
• 
  Delete TableDeletes a table from a NocoDB base permanently.
• 
  Delete Table RecordsDeletes one or more records from a NocoDB table.
• 
  Get Base MetaReturns metadata for a specific NocoDB base.
• 
  Get DocumentReturns a single document by its ID.
• 
  Get FieldReturns the definition of a specific field in a NocoDB base.
• 
  Get Table SchemaReturns the full schema (fields, views) for a NocoDB table.
• 
  Invite Base UsersInvites one or more users to a NocoDB base.
• 
  Link RecordsCreates links between records via a link/relation field.
• 
  List BasesReturns a list of bases in a NocoDB workspace.
• 
  List Base UsersReturns members of a NocoDB base.
• 
  List DocumentsReturns documents for a NocoDB base. Requires Business+ or Enterprise plan.
• 
  List Linked RecordsReturns linked records for a specific link field on a record.
• 
  List Table RecordsReturns a paginated list of records from a NocoDB table.
• 
  List TablesReturns a list of tables in a NocoDB base.
• 
  List View FiltersReturns filter groups for a NocoDB view. Use the List View Filters RPC to get individual leaf filter IDs.
• 
  List ViewsReturns a list of views for a NocoDB table.
• 
  List View SortsReturns a list of sort rules for a NocoDB view.
• 
  Make an API CallPerforms an arbitrary authorized API request to the NocoDB v3 API.
• 
  Read Table RecordReturns a single record from a NocoDB table by its ID.
• 
  Reorder DocumentChanges the display order of a document in a NocoDB base.
• 
  Replace View FiltersReplaces the entire filter set for a NocoDB view.
• 
  Unlink RecordsRemoves links between records via a link/relation field.
• 
  Update BaseUpdates metadata for a NocoDB base.
• 
  Update Base UsersUpdates roles or properties for users in a NocoDB base.
• 
  Update DocumentUpdates an existing document in a NocoDB base.
• 
  Update FieldUpdates the definition of a field in a NocoDB base.
• 
  Update FilterUpdates an existing filter on a NocoDB view.
• 
  Update SortUpdates an existing sort rule on a NocoDB view.
• 
  Update TableUpdates the title or properties of a NocoDB table.
• 
  Update Table RecordsUpdates one or more existing records in a NocoDB table.