Content Comparison

...

• Crud using Rest API with Model in Workflow:

• To Fetch Records:

  • Create a New layout

  • 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

    Image Removed
  And add condition on connector mapping after Rest API action i.e. Model : Sales Connect

  new workflow (defining Label and Name)

  • Show Spinner Action:

    • Drag and drop the "Show Spinner Action"

    • Define layout item (e.g., Table), variant, and size

  • Rest API Action:

    • Drag and drop the "Rest API Action"

    • Set the Source API Type to Model

    • Choose the Model (e.g., Sales Connect) assigned to the Table

  • Hide Spinner Action:

    • Drag and drop the "Hide Spinner Action"

    • Define the layout item

  • Connect Actions:

    • Connect the actions in the workflow

    Image Added

  • Add Condition on Connector Mapping:

    • After the Rest API Action, set a condition on connector mapping

    • Condition: Model: Sales Connect, Set Output > Response: data

    

  • 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

    • Preview:

      • On

      Preview Click

      • preview, click on the Refresh Button

      ,

      • .

      • The Get workflow will be executed, fetching the records.

• To Create Records:

  • Create a New Layout

  • Method: POST

  • URL: Provide the endpoint for creating records.

  • Body: Define the data to be created using the Model and Schema.

...