# Query Profile for API with Body Data Parameters and Dynamic Fields selection

**URL:** <https://matillioncommunity.discourse.group/t/query-profile-for-api-with-body-data-parameters-and-dynamic-fields-selection/2440>\
**Category:** Matillion ETL\
**Created:** [August 1, 2024, 3:29pm UTC](https://matillioncommunity.discourse.group/t/query-profile-for-api-with-body-data-parameters-and-dynamic-fields-selection/2440 "2024-08-01T15:29:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![S\_VASHCHENKO](https://avatars.discourse-cdn.com/v4/letter/s/ba9def/32.png) [@S\_VASHCHENKO](https://matillioncommunity.discourse.group/u/S_VASHCHENKO)\
**Post date:** [August 1, 2024, 3:29pm UTC](https://matillioncommunity.discourse.group/t/query-profile-for-api-with-body-data-parameters-and-dynamic-fields-selection/2440/1 "2024-08-01T15:29:59Z")

</div>

Hello,

&nbsp;

Working on the ETL piece that calls API with Body Data Parameter and Dynamic Fields selection as URI parameter. Below is Query Profile for it that works.

&nbsp;

 ![069Tm000007NhDEIA0_0D5Tm00000GmknxKAB](https://us1.discourse-cdn.com/flex002/uploads/matillioncommunity/original/1X/e533f3d5d1a4c50df94265a00e69567215eb49d0.png)

However if I enable body data parameter and pass JSON Value to it, API returns only first cpolumn (id) and the rest of the columns are blank. What am I doing wrong here? Everything works great in POSTMAN.

---

<div class="post-metadata">

**Author:** ![Joe-Community-Manager](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/joe-community-manager/32/897_2.png) [@Joe-Community-Manager](https://matillioncommunity.discourse.group/u/Joe-Community-Manager)\
**Post date:** [August 12, 2024, 11:04am UTC](https://matillioncommunity.discourse.group/t/query-profile-for-api-with-body-data-parameters-and-dynamic-fields-selection/2440/2 "2024-08-12T11:04:35Z")

</div>

Hi [@S\_VASHCHENKO](https://matillioncommunity.discourse.group/u/S_VASHCHENKO)​

Thank you for your post and welcome to the Matillion Community, I have raised a support case for you regarding this as it will need our support team to take a closer look for you and diagnose.

They will be in contact shortly.

Kind regards, Joe
