...
To Fetch Records:
Table Setup:
Drag and drop a Table component onto layout Designer
Add Table action as New and Refresh
Add row action on Table as Edit and Delete
Assign Model to Component:
Assign a model to the Table with the following details:
Type: API
Connection: Choose a connection e.g. Sales Connect
Label gets Auto-populates e.g. Sales Connect
Name gets Auto-populates e.g. Sales Connect
Request:
Method: GET
URL: /services/data/v56.0/query?q=select id,name,site from account
Record Count: Multirecord
Response:
Define or create a schema to fetch the response. This schema will structure the data received from the API call
Code Block { "data": { "records": { "Name": "Test", "Id": "123456789", "Site": "Pune" } } }
In Component Attributes:
Basic:
Model: Select the model e.g. Sales Connect
Schema Source: Select "Response" as the source
Response code: Set the response code to 200
In Fields:
Select data > record
Click on the Table component, and the Model fields will be displayed on the left side
Drag drop the fields on the Table component
Create a workflow follow the steps we create it
Drag drop Show Spinner Action and define layout item i.e. Table, variant and size
Drag drop Rest API Action define
Source API Type: Model
Model: Select The model assign to the Table e.g. Sales connect
Drag drop Hide Spinner Action and define layout item
Connect the action
And add condition on connector mapping after Rest API action i.e. Show Spinner------>Rest API Action---Add connector mapping condition Model : Sales Connect Set Output > Response: data --->Hide Spinner
Save the workflow
Call the workflow on component events
Refresh : tableAction
Select Action as Workflow
Select Config and define Select Workflow: (Select the workflow create for Get e.g. Get and Save
Save & Run the Layout
On Preview Click on Refresh Button, Get workflow will be executed fetching the records
...