# HttpConnector not reading from column

**URL:** https://forum.cloverdx.com/t/httpconnector-not-reading-from-column/2162
**Category:** CloverDX Platform
**Created:** [May 29, 2024, 8:29am UTC](https://forum.cloverdx.com/t/httpconnector-not-reading-from-column/2162 "2024-05-29T08:29:50Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Mahmood\_Babalola](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@Mahmood\_Babalola](https://forum.cloverdx.com/u/Mahmood_Babalola)
#### Post date: [May 29, 2024, 8:29am UTC](https://forum.cloverdx.com/t/httpconnector-not-reading-from-column/2162/1 "2024-05-29T08:29:50Z")

</div>

I am trying to use the HTTPconnector to run an API to extract a column and put it in a certain column in the database. I am able to do it successfully when I put the body of the call in "requestContent’ for one call

$out.0.requestContent = ‘https//whateverthelink’;

I need to do this for hundreds of records. so I put the body of the call in a column and called the

"requestContent = ‘$in.0.TheColumn’

but this is not working, It is not reading the body of the call from the column, i think it is has something to do with the way httpconnector is set up, can someone kindly help me with this?

---

<div class="post-metadata">

### Author: ![Tomas\_Pavlas](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/tomas_pavlas/32/170_2.png) [@Tomas\_Pavlas](https://forum.cloverdx.com/u/Tomas_Pavlas)
#### Post date: [June 3, 2024, 1:09pm UTC](https://forum.cloverdx.com/t/httpconnector-not-reading-from-column/2162/2 "2024-06-03T13:09:07Z")

</div>

Hi Mahmood,

The HTTPConnector can work with dynamic input. However, the Request Content needs to be properly formatted according to the API you are using.

Let me give you an example using our REST API, specifically for creating a new sandbox.

 ![](https://canada1.discourse-cdn.com/flex007/uploads/cloverdx1/original/1X/d80dbb7dab3d78391df535592842563bdb567c94.png)

The DataGenerator generates random codes for the sandboxes to be created. The crucial step is wrapping the input from the DataGenerator into the proper format in the Input Mapping of the HTTPConnector.

For our REST API, the format must follow the JSON structure, so the Request Content should be:  
{  
“code”: “MyNewSandbox”  
}

To achieve creating sandboxes dynamically using the DataGenerator inputs, the formula in HTTPConnector Input Mapping must be as follows to represent proper format of the request:

**function**  **integer**  **transform** () {  
\*\*$out.\*\*0.requestContent = “{ \“code\”: \”" + \*\*$in.\*\*0.sandboxName + “\”}";

Keep in mind that if you want to include quotation marks inside a string, you need to use a backslash (`\`) as an escape character. This is necessary because quotation marks have a special meaning - they define the beginning and end of a string. The escape character ensures that the quotation marks are treated as part of the string and not as the end or beginning of the string.

Best regards, Tom.