How to reference array values in another table?

Hi!

I’m setting up integrations as data sources, and my users will create their own workflows for these integrations. I’d like to create for each integration separate actions (based on the integration’s api).

In table 1 called “integrations”, I made a jsonb array field for “actions”
This field would contain an array of values like [“get_calls”,“get_users”].

Table 2 called “integration_workflows” should have a field to reference what type of action the workflow should have.

Is it possible to somehow make a reference in “integration_workflows” to what action the record is related to, in the array of actions in “integrations”?

Community Page
Last updated: