topic Hi, need help to output multiple records to api endpoint response. in Workato Pros Discussion Board

Hi, need help to output multiple records to api endpoint response.

darren-chow — Tue, 05 Jul 2022 11:36:45 GMT

Hi, need help to output multiple records to api endpoint response.

Re: Hi, need help to output multiple records to api endpoint response.

umar-aalam — Tue, 05 Jul 2022 11:44:21 GMT

pls elaborate it like what schema you are using, is this in form of array etc. I fetched multiple records using API endpoints. I might help you

Re: Hi, need help to output multiple records to api endpoint response.

darren-chow — Tue, 05 Jul 2022 11:50:50 GMT

hi.. so i making an api endpoint that receives a parameter and returns a list of records as response.. i am having trouble returning all the records as response.. as currently i am only able to return one record..

Re: Hi, need help to output multiple records to api endpoint response.

jblanchett — Tue, 05 Jul 2022 12:00:44 GMT

Edit your response schema to be an array then return a list of records that way

Re: Hi, need help to output multiple records to api endpoint response.

roland-daane — Tue, 05 Jul 2022 12:49:31 GMT

If you share a copy of your recipe we could have a look.

On the output tab of the call that returns 1 record, expand the output and past the json in this chat.

If you use an array, it can contain multiple records.

Which platform are you connecting with?

Re: Hi, need help to output multiple records to api endpoint response.

darren-chow — Tue, 05 Jul 2022 14:00:08 GMT

my response schema looks like this:

[

{

"label": "Opportunity",

"type": "object",

"name": "Opportunity",

"properties": [

{

"control_type": "text",

"label": "Name",

"type": "string",

"name": "name"

{

"name": "amount",

"type": "string",

"optional": false,

"control_type": "text"

{

"name": "description",

"type": "string",

"optional": false,

"control_type": "text"

}

]

{

"label": "Issue",

"type": "object",

"name": "Issue",

"properties": [

{

"control_type": "text",

"label": "Name",

"type": "string",

"name": "name"

}

]

}

]

Re: Hi, need help to output multiple records to api endpoint response.

roy-deckers — Wed, 06 Jul 2022 20:49:42 GMT

hi Darren

Can you try this one:

[

{

"name": "Opportunity",

"type": "array",

"of": "object",

"label": "Opportunity",

"optional": false,

"properties": [

{

"control_type": "text",

"label": "Name",

"type": "string",

"name": "name",

"optional": true

{

"control_type": "text",

"label": "Amount",

"name": "amount",

"type": "string",

"optional": true

{

"control_type": "text",

"label": "Description",

"name": "description",

"type": "string",

"optional": true

}

]

{

"name": "Issue",

"type": "array",

"of": "object",

"label": "Issue",

"optional": true,

"properties": [

{

"control_type": "text",

"label": "Name",

"type": "string",

"name": "name"

}

]

}

]

Re: Hi, need help to output multiple records to api endpoint response.

darren-chow — Wed, 06 Jul 2022 20:51:48 GMT

Thanks.. this solves it!