Skip to main content

Get a data of a particular flow from BigQuery

Get Data for a Specific Flow from BigQuery:

  • Login to your Google account https://console.cloud.google.com/

  • Click on Big Query Tab

  • Click on small trangle next to your project ID

  • Click on small trangle next to the your BOT number

  • Click on any of the table.

  • In the right pane clikc on Query Tab in the Split tab

  • Write the below query to get the results of a single flow

  • SELECT * FROM your_dataset.messages where flow_name = flow_name order by inserted_at DESC

    Extract Data by Flow from BigQuery:

  • The following query can be used to extract data by flow.

WITH extracted_json AS (
SELECT
contact_phone,
contact_name,
JSON_EXTRACT_SCALAR(results, '$.feedback_positive.input') AS feedback_positive,
JSON_EXTRACT_SCALAR(results, '$.result_q1_pos.input') AS result_q1_pos,
JSON_EXTRACT_SCALAR(results, '$.result_q2_pos.input') AS result_q2_pos,
JSON_EXTRACT_SCALAR(results, '$.result_q3_pos.input') AS result_q3_pos
FROM
`your_project.your_dataset.your_table` where uuid = "flow_uuid"
)
SELECT * FROM extracted_json;
  • All flow results must be added in a similar manner:

JSON_EXTRACT_SCALAR(results, '$.flow_result.input') AS flow_result,

  • Running the query will generate a table displaying phone numbers, names, and their flow results, which can then be exported as a CSV.