# Issue exporting multiple records in Celigo flow

**URL:** <https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771>\
**Category:** Integrator.io\
**Tags:** export\
**Created:** [October 24, 2025, 7:48am UTC](https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771 "2025-10-24T07:48:45Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vyshnavi\_Nadimpally](https://avatars.discourse-cdn.com/v4/letter/v/bc79bd/32.png) [@Vyshnavi\_Nadimpally](https://connective.celigo.com/u/Vyshnavi_Nadimpally)\
**Post date:** [October 24, 2025, 7:48am UTC](https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771/1 "2025-10-24T07:48:45Z")

</div>

I have an export in one of the celigo flows in which i am trying to export records from Generic Inquiry in Acumatica. We have set up the Generic Inquiry to pull specific fields from a table (it is kind of database view where we pull all fields we need). But the issue is ‘it is exporting only one record’ and so updating only one record in the destination. I have selected ‘Export all data’ , also tried grouping the records ‘ContractCD’ value (you can find this in screenshot). Still no luck. Any suggestions would be helpful.

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/1/1bdc7a05dc8079f8832abb49a1776e6da38b1ced.png)

Thank you

---

<div class="post-metadata">

**Author:** ![kellyizer](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kellyizer/32/4369_2.png) [@kellyizer](https://connective.celigo.com/u/kellyizer)\
**Post date:** [October 28, 2025, 8:24pm UTC](https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771/2 "2025-10-28T20:24:21Z")

</div>

> [@Vyshnavi\_Nadimpally](#):
>
> I have an export in one of the celigo flows in which i am trying to export records from Generic Inquiry in Acumatica. We have set up the Generic Inquiry to pull specific fields from a table (it is kind of database view where we pull all fields we need). But the issue is ‘it is exporting only one record’ and so updating only one record in the destination. I have selected ‘Export all data’ , also tried grouping the records ‘ContractCD’ value

Vyshnavi, if I am correct an Acumatica Generic Inquiry response looks something like this

```auto
{
  "@odata.context": "...",
  "value": [
    {
      "Field1": "Record 1 Value A",
      "Field2": "Record 1 Value B",
      "Field3": "Record 1 Value C"
    },
    {
      "Field1": "Record 2 Value A",
      "Field2": "Record 2 Value B",
      "Field3": "Record 2 Value C"
    },
    // ... continues for all records
  ]
}

```

So in order to get [Integrator.IO](http://Integrator.IO) to recognize each record (instead of the array) you will want to set the “ **Path to records in HTTP response body** “ in the export to ‘value‘.

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/39e124f435412212cfa21b6350d9c35340f301c9.jpeg)

Then [Integrator.IO](http://Integrator.IO) will present you with each record in subsequent steps.

Please give that a try and see if it resolves the issue.

---

<div class="post-metadata">

**Author:** ![Vyshnavi\_Nadimpally](https://avatars.discourse-cdn.com/v4/letter/v/bc79bd/32.png) [@Vyshnavi\_Nadimpally](https://connective.celigo.com/u/Vyshnavi_Nadimpally)\
**Post date:** [October 28, 2025, 9:08pm UTC](https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771/3 "2025-10-28T21:08:27Z")

</div>

Hi Kelly,

Thank you very much for the reply. Here is what i am getting from Acumatica GI. Do i need to add ‘Tranformation’ step to transform the json..?? Because with this JSON even if i enter ‘rows’ or ‘page\_of\_records’, it is returning empty response.

```json
{
    "page_of_records": [
        {
            "rows": [
                {
                    "id": "71c6eb23-b796-45a7-96b0-44ee09918b1c",
                    "rowNumber": 1,
                    "note": null,
                    "AccountGroupID": {
                        "value": 60
                    },
                    "Asset": {
                        "value": 0
                    },
                    "BaseTypePMProject_BaseType": {
                        "value": "P"
                    },
                    "BaseTypeRXSingleLineProjectTotals_baseType": {
                        "value": "P"
                    },
                    "ContractCD": {
                        "value": "CS0001768"
                    },
                    "ContractID": {
                        "value": 201497
                    },
                    "CostCodeID": {
                        "value": 237
                    },
                    "CuryID": {
                        "value": "USD"
                    },
                    "CuryInfoID": {
                        "value": 14331429
                    },
                    "Description": {
                        "value": "TEST ONLY Desc edit"
                    },
                    "EplusA": {
                        "value": "30.0000"
                    },
                    "Expense": {
                        "value": 30
                    },
                    "Income": {
                        "value": "0.0000"
                    },
                    "InventoryID": {
                        "value": 10046
                    },
                    "LastModifiedDateTime": {
                        "value": "2025-10-24T07:08:51.14+00:00"
                    },
                    "Liability": {
                        "value": 0
                    },
                    "NoteID": {
                        "value": "e16d1c9f-da3f-f011-837f-0eddcec71d29"
                    },
                    "Program": {
                        "value": "CNTR0010284"
                    },
                    "ProgramName": {
                        "value": "TEST VN - 6.2"
                    },
                    "ProjectIDPMProject_ContractCD": {
                        "value": "CS0001768"
                    },
                    "ProjectIDRXSingleLineProjectTotals_projectID": {
                        "value": 201497
                    },
                    "ProjectTaskID": {
                        "value": 2994797
                    },
                    "ServiceNowID": {
                        "value": "e2e67a831b316a5083faca20604bcb2b"
                    },
                    "UsrDQStage": {
                        "value": "Invoiced"
                    },
                    "custom": {}
                }
            ]
        }
    ]
}

```

---

<div class="post-metadata">

**Author:** ![Vyshnavi\_Nadimpally](https://avatars.discourse-cdn.com/v4/letter/v/bc79bd/32.png) [@Vyshnavi\_Nadimpally](https://connective.celigo.com/u/Vyshnavi_Nadimpally)\
**Post date:** [October 28, 2025, 9:10pm UTC](https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771/4 "2025-10-28T21:10:30Z")

</div>

ServiceNowID field is the unique field i want to use to differentiate each record. So i have given ‘ServiceNowID.value’ in grouping the records option in export.

---

<div class="post-metadata">

**Author:** ![Vyshnavi\_Nadimpally](https://avatars.discourse-cdn.com/v4/letter/v/bc79bd/32.png) [@Vyshnavi\_Nadimpally](https://connective.celigo.com/u/Vyshnavi_Nadimpally)\
**Post date:** [October 28, 2025, 9:20pm UTC](https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771/5 "2025-10-28T21:20:48Z")

</div>

If i remove the ‘grouping by record’, then it will not array through rows. and it returns JSON response as shown in screenshot.

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/7/7bb47d6898c9fb62a08eaaeaacc3223795b9f7bd.png)

---

<div class="post-metadata">

**Author:** ![kellyizer](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kellyizer/32/4369_2.png) [@kellyizer](https://connective.celigo.com/u/kellyizer)\
**Post date:** [October 28, 2025, 9:23pm UTC](https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771/6 "2025-10-28T21:23:40Z")

</div>

On the preview, can you select the HTTP response option (not the parsed output) option and show us what that looks like please

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/03648bcfcf4c1e7b13f94bb5c8befb7841f587a3.jpeg)

Also, Since you mentioned trying to group by `ServiceNowID`, are you doing that on the Generic Inquiry in Acumatica or via the settings in [Integrator.IO](http://Integrator.IO)?

Can you please try removing the grouping for now until you validate you are getting the correct data.

Thank you.

---

<div class="post-metadata">

**Author:** ![Vyshnavi\_Nadimpally](https://avatars.discourse-cdn.com/v4/letter/v/bc79bd/32.png) [@Vyshnavi\_Nadimpally](https://connective.celigo.com/u/Vyshnavi_Nadimpally)\
**Post date:** [October 28, 2025, 9:28pm UTC](https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771/7 "2025-10-28T21:28:17Z")

</div>

Sure. I removed the grouping. Here is the screenshot for HTTP response.

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/8/86e7fab4947732a95bbdf4501bf527c7d55c469d.png)

---

<div class="post-metadata">

**Author:** ![kellyizer](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kellyizer/32/4369_2.png) [@kellyizer](https://connective.celigo.com/u/kellyizer)\
**Post date:** [October 28, 2025, 9:58pm UTC](https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771/8 "2025-10-28T21:58:46Z")

</div>

in your previous example you had a ROWS array. it doesn’t appear to be there in the HTTP response, did you change something else before taking that screenshot? I would have expected the ROWS to still be there.

```auto
{
    "page_of_records": [
        {
            "rows": [
                {
                    "id": "71c6eb23-b796-45a7-96b0-44ee09918b1c",
                    "rowNumber": 1,
                    "note": null,
                    "AccountGroupID": {
                        "value": 60
                    },
                    "Asset": {
                        "value": 0
                    },
                    "BaseTypePMProject_BaseType": {
                        "value": "P"
                    },
                    "BaseTypeRXSingleLineProjectTotals_baseType": {
                        "value": "P"
                    },
                    "ContractCD": {
                        "value": "CS0001768"
                    },
                    "ContractID": {
                        "value": 201497
                    },
                    "CostCodeID": {
                        "value": 237
                    },
                    "CuryID": {
                        "value": "USD"
                    },
                    "CuryInfoID": {
                        "value": 14331429
                    },
                    "Description": {
                        "value": "TEST ONLY Desc edit"
                    },
                    "EplusA": {
                        "value": "30.0000"
                    },
                    "Expense": {
                        "value": 30
                    },
                    "Income": {
                        "value": "0.0000"
                    },
                    "InventoryID": {
                        "value": 10046
                    },
                    "LastModifiedDateTime": {
                        "value": "2025-10-24T07:08:51.14+00:00"
                    },
                    "Liability": {
                        "value": 0
                    },
                    "NoteID": {
                        "value": "e16d1c9f-da3f-f011-837f-0eddcec71d29"
                    },
                    "Program": {
                        "value": "CNTR0010284"
                    },
                    "ProgramName": {
                        "value": "TEST VN - 6.2"
                    },
                    "ProjectIDPMProject_ContractCD": {
                        "value": "CS0001768"
                    },
                    "ProjectIDRXSingleLineProjectTotals_projectID": {
                        "value": 201497
                    },
                    "ProjectTaskID": {
                        "value": 2994797
                    },
                    "ServiceNowID": {
                        "value": "e2e67a831b316a5083faca20604bcb2b"
                    },
                    "UsrDQStage": {
                        "value": "Invoiced"
                    },
                    "custom": {}
                }
            ]
        }
    ]
}

```

This may have something to do with the grouping you had. If you are were trying to group by ServiceNowID and there was only one record with that ID then IO would only show the one records in the grouping since that is all that exists.

The preview button will only show a subset of your data, If you actually run the flow you may get all of the expected records.

---

<div class="post-metadata">

**Author:** ![Vyshnavi\_Nadimpally](https://avatars.discourse-cdn.com/v4/letter/v/bc79bd/32.png) [@Vyshnavi\_Nadimpally](https://connective.celigo.com/u/Vyshnavi_Nadimpally)\
**Post date:** [October 29, 2025, 5:34am UTC](https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771/9 "2025-10-29T05:34:00Z")

</div>

Hey Kelly,

HTTP response stays the same as shown in the above screenshot without any ROWS array, with or without grouping. I have sent you Parsed Output before which had ‘ROWS’.

I have tried running the flow thinking the same, that preview might be just showing single record. But it did not update multiple records, it only updated the one showing in the preview.

If HTTP response shows like below, with or wothout grouping, are there any other setting i need to do interms of export scenario OR is there anything else i can try with ‘Path to records in HTTP response body’..??? or will i need to transform the JSON to accept multiple records..?? Please assist

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/51b1db9257789812b4b3937a55ed147e86ecbca8.png)

---

<div class="post-metadata">

**Author:** ![basvanditzhuijzen](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/basvanditzhuijzen/32/4422_2.png) [@basvanditzhuijzen](https://connective.celigo.com/u/basvanditzhuijzen)\
**Post date:** [October 29, 2025, 8:37am UTC](https://connective.celigo.com/t/issue-exporting-multiple-records-in-celigo-flow/5771/10 "2025-10-29T08:37:12Z")

</div>

Hi, Based on the screenshot of the http response, It looks to me like your API is only returning one record and not multiple. You can verify this in Postman.

For example here is a screenshot of a call to the Acumatica Customers endpoint, the HTTP response shows that Acumatica is returning an json array containing multiple customer objects:

 ![image](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/c/c1d2d6a6daf207b2d6f12ed324a5774206ec05d5.png)