I want to send a post request with excel repeating it for each row where I will be providing each hostId.

Example Format

2.PNG


URL:
https://www.niagara-central.com/ws/l...31/getByHostId

BODY:
<req path="/ws/license/api31/getByHostId">
<params hostId="Qnx-TITAN-7FF9-02B6-E138-CE66" clientVersion="4.12"/>
</req>


And take this lines output into columns

<resp><licensefile modelName='J-8025' modelDisplayName='J-8000 WITH 25 DEVICE LIMIT' brandDisplayName='Vykon' licenseKey='02A-60E1-0015-6CA' version='4.12'><license vendor="Tridium" expiration="never" hostId="Qnx-TITAN-69FA-4811-27B0-7EC8" serialNumber="80299384" version="4.12" generated="2023-03-08" maintenanceExpiration="2023-12-28">




Capture.PNG