api recipe to return all the records currently on the Test interface

Jelly1118 — Fri, 24 Jan 2025 03:48:15 GMT

How can i make my Api recipe with action as a sql server to display all the records i can currently see only 1 record when testing on test interface

Re: api recipe to return all the records currently on the Test interface

Jelly1118 — Fri, 24 Jan 2025 04:13:02 GMT

[
{
"name": "FromLocation",
"type": "string",
"optional": false,
"label": "From Location",
"control_type": "text"
},
{
"name": "GuestName",
"type": "string",
"optional": false,
"label": "Employee Name",
"control_type": "text"
},
{
"name": "Iscancelled",
"type": "boolean",
"optional": false,
"label": "Iscancelled",
"control_type": "checkbox",
"render_input": "boolean_conversion",
"parse_output": "boolean_conversion",
"toggle_hint": "Select from option list",
"toggle_field": {
"label": "Iscancelled",
"control_type": "text",
"toggle_hint": "Use custom value",
"name": "Iscancelled",
"type": "boolean",
"optional": false
}
},
{
"name": "PNR",
"type": "string",
"optional": false,
"label": "PNR",
"control_type": "text"
},
{
"name": "SeatType",
"type": "string",
"optional": false,
"label": "Seat Type",
"control_type": "text"
},
{
"name": "ToLocation",
"type": "string",
"optional": false,
"label": "To Location",
"control_type": "text"
},
{
"name": "ttime",
"type": "date_time",
"optional": false,
"label": "Timestamp",
"control_type": "date_time",
"render_input": "date_time_conversion",
"parse_output": "date_time_conversion"
},
{
"name": "xDepartment",
"type": "string",
"optional": false,
"label": "Department",
"control_type": "text"
},
{
"name": "xEndDate",
"type": "string",
"optional": false,
"label": "EndDate",
"control_type": "text"
},
{
"name": "xStartDate",
"type": "string",
"optional": false,
"label": "StartDate",
"control_type": "text"
},
{
"name": "CIRYSID",
"type": "integer",
"optional": false,
"label": "CIRYSID",
"control_type": "integer",
"parse_output": "integer_conversion"
}
]

Re: api recipe to return all the records currently on the Test interface

Jelly1118 — Fri, 24 Jan 2025 05:59:53 GMT

Was able to resolve this. Thank you

Re: api recipe to return all the records currently on the Test interface

Prudvi — Fri, 24 Jan 2025 17:41:49 GMT

Hi @Jelly1118,
Could you please let us know how was it resolved.
Regards,
Prudvi

topic Re: api recipe to return all the records currently on the Test interface in Workato Pros Discussion Board

api recipe to return all the records currently on the Test interface

Re: api recipe to return all the records currently on the Test interface

Re: api recipe to return all the records currently on the Test interface

Re: api recipe to return all the records currently on the Test interface