Get Record
Usage
This action is used to get a record’s information in an apps’ database in Google Appsheet.
Fields
-
Connection - Here you authorize a connection to your app using api id and key for Zenphi.
-
Table Name -This field is used to choose the table that you want to get a record from.
-
Column Name(Primary Key) - Here you enter the name of the key column.
-
Columns Value - here you enter the value of key column for the record(ID).
-
Columns of the table to read - here you specify the columns that you want to retrieve data from in that record.
Demonstration on how to use it in a flow
-
Drag and drop Get Record action into the flow.
-
The Name section is pre-filled by the action name but you can configure this section according to your preference.
-
Click the gear icon to open its settings.
-
Authorize a connection for Zenphi.
-
Enter the table’s name.
-
Enter the key column’s name.
-
Enter the value of the key column of the record that you want to get information on.
-
Specify the columns in the record that you need to retrieve.