Discussion about MY API response

API Management
1

Hi all,

I am working with Celigo My API. I am facing an issue with API response. I need response as a json array but Celigo API response giving as a json object. Can anyone knows how to achieve this.

Current response as Json object:

{
  "code": 0,
  "isSuccess": true,
  "message": ""
}

I need response like below as Json array:

[
    {
        "code": 0,
        "isSuccess": true,
        "message": ""
    }
]
2

Hi @saivamsi_Jeedimalla

In API builder, returning a JSON object is currently supported. In order to return an array, it is recommended to configure the API response body as an object array like shown below.

A user interface for configuring an API response with options for setting HTTP status code, headers, and response body schema. (Captioned by AI)
A user interface for configuring an API response with options for setting HTTP status code, headers, and response body schema. (Captioned by AI)2148×1802 306 KB

Once the mapping is configured, and API is invoked, the response is returned as an object array.

The image shows a software interface for editing a mapping response, with fields for configuring source and destination data types and additional settings. (Captioned by AI)
The image shows a software interface for editing a mapping response, with fields for configuring source and destination data types and additional settings. (Captioned by AI)2610×1388 238 KB

The image shows a JSON response from an API request displaying Shopify order details in a dark-themed interface. (Captioned by AI)
The image shows a JSON response from an API request displaying Shopify order details in a dark-themed interface. (Captioned by AI)2610×1388 275 KB

Hope this works.. Also is there any particular use case for which you are looking to send a JSON array as response?

Thanks,
Kaustav

3

Hi @kaustavroy ,

Thank you for the response.

We need the data in Json array because there is a parser which is accepting the entire data in array format. I need to pass entire data set as a json array to that parser. please refer to the below screenshot the highlighted part needs to be in array.

The image shows a JSON response body in an API testing application with a successful 200 OK status. (Captioned by AI)
The image shows a JSON response body in an API testing application with a successful 200 OK status. (Captioned by AI)1355×852 41.3 KB

4

Thank you @saivamsi_Jeedimalla for your valuable suggestion. We will reach out to you to explore this further and add it to our roadmap.

5

@kaustavroy Hope you are doing well.

We are currently facing the same issue with the response format. As Vamsi mentioned earlier, we require the response to be returned as an array, however it is returned as an object. Please let us know if there are any updates on this request raised. Or suggest alternate (if any) we can use to achieve the array format.

Thank you for your support.

6

Hi Pradeep, this has been added to our roadmap. We can meet early next week to discuss this further.