Hi,
I’m new to CloverETL and already have my first problem. It would be really great if someone could give me a hint:
I’m importing different unique IDs and some data from an Excel sheet. Now I want to process for each ID the Json-Reader on a specific URL with the ID as an attribute. I have no idea how to do this. Is that even possible?
Thank you!
Peter
Hi,
Yes, it is possible to read URL in the component and subsequently put the URL to another component as an attribute. In your specifically case, please connect the component which reads data from the Excel sheet with the JSONReader component through edge. Create metadata for this edge - just one string field for the URL. In the JSONReader set the attribute “File URL” by the “URL Dialog” (The URL dialog can be opened when you edit the “File URL” attribute - click on the icon with three dots on the right). In the “URL Dialog” please select “Port” tab. There you can select field from the metadata which contains the URL.
I hope it will help you. Please feel free to ask with any other question you might have.