Executing URL using Apache HttpClient
Efficiency

In response to

// do I need to create this everytime for each call?
HttpClient httpclient = HttpClientBuilder.create().build();


Then no. The construction doesn't take any parameter, so it's independent from the loop and you can initialize only once before the loop. And although the javadoc for those methods is empty, by the looks of .create().build() I'd say that it's not a cheap instantiation.

Simplification

You can save some lines by using IOUtils to read the content from the response, as explained in this answer.

Readability

Your function is a bit too long. You can probably divide it into smaller functions. I would start extracting the try/catch block into a readResponse() method.

Miscellaneous

This

HttpStatus.OK.value()


is from Spring. There's nothing wrong with it, but since you're using an Apache library, why don't you use HttpStatus from the Apache library?