# Results Mapping not passing all values to JSON object

**URL:** <https://connective.celigo.com/t/results-mapping-not-passing-all-values-to-json-object/868>\
**Category:** Integrator.io\
**Tags:** database, sql, mapper, json, lookup\
**Created:** [January 6, 2022, 5:43pm UTC](https://connective.celigo.com/t/results-mapping-not-passing-all-values-to-json-object/868 "2022-01-06T17:43:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![davidromstad](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@davidromstad](https://connective.celigo.com/u/davidromstad)\
**Post date:** [January 6, 2022, 5:43pm UTC](https://connective.celigo.com/t/results-mapping-not-passing-all-values-to-json-object/868/1 "2022-01-06T17:43:42Z")

</div>

I am using a SQL lookup to get data

 ![5301043caa20740200000001-e8a7ed46f1ca47c8b5f69b27552b65f1.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/25f7b0af6a49333a03c795025733e021bc251600.png)

And this is giving me two records and could potentially be an infinite number.

 ![5301043caa20740200000001-af496a99e65a4275ae1a8505c553d1f8.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/0/05dc4cd55ff7c56dbcb5d1c57521cbf56982bced.png)

I defined the results mapping and it's getting passed to the PostResponseMapData but only one value instead of multiple values.

 ![5301043caa20740200000001-0b74a7047c3846df995328419e7ccc33.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/51a9f4d47e6847c362a806b81c2a9af581be73f3.png)

![5301043caa20740200000001-d8eef969f43b486b93369b086cb9ac09.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/2bb39b5856b7b31cf3e7dfbd5e49dfb5449db035.png)

How do I pass all records to the JSON object?

---

<div class="post-metadata">

**Author:** ![katelarson](https://avatars.discourse-cdn.com/v4/letter/k/91b2a8/32.png) [@katelarson](https://connective.celigo.com/u/katelarson)\
**Post date:** [January 7, 2022, 9:49pm UTC](https://connective.celigo.com/t/results-mapping-not-passing-all-values-to-json-object/868/2 "2022-01-07T21:49:49Z")

</div>

Hi @davidromstad - It looks like you created a Support ticket for this, which is a good way to proceed. Once it's resolved if you have a minute to post a follow-up here in case anyone else runs in to this down the line, it's most appreciated. Thanks!

---

<div class="post-metadata">

**Author:** ![davidromstad](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@davidromstad](https://connective.celigo.com/u/davidromstad)\
**Post date:** [January 13, 2022, 7:25pm UTC](https://connective.celigo.com/t/results-mapping-not-passing-all-values-to-json-object/868/3 "2022-01-13T19:25:20Z")

</div>

Response from the support ticket.

The reason why it is only showing 1 record is that Celigo processes the job per record.  
For viewing purposes, if you want to see all the records in your PostResponseMapData, you need to copy all the records shown in your export and copy them to your PostResponseMapData.  
  
Although, please do note that when you run the flow, Celigo will still process them one record at a time.

This is solved by manually putting in the data that is missing into the JSON object of the PostResponse Hook and then previewing the data.

---

<div class="post-metadata">

**Author:** ![katelarson](https://avatars.discourse-cdn.com/v4/letter/k/91b2a8/32.png) [@katelarson](https://connective.celigo.com/u/katelarson)\
**Post date:** [January 13, 2022, 8:52pm UTC](https://connective.celigo.com/t/results-mapping-not-passing-all-values-to-json-object/868/4 "2022-01-13T20:52:18Z")

</div>

Thanks so much for the follow-up, @davidromstad!