I have a scenario where I’m trying to iterate through cells in a column (in a Google Sheet) that contains URL links for websites of companies, to make a HTTP request and get the HTML text content of each website.
1- I have the Search a Row module as the data source of the Google Sheet. Then this is followed by an HTTP request to make requests to all the URL links in column ‘E’. But in the HTTP request module I’m getting the error
BundleValidationError Validation failed for 1 parameter(s). Missing value of required parameter ‘url’.
I tried running the HTTP request module with a static URL link value and it worked. So clearly the issue is with the mapping of the Column ‘E’ dynamic value to the HTTP request module. Any help would be really appreciated.
Thank you so much for going out of your way to create the video. Really appreciated. Unfortunately, I did exactly the same thing as you (at least from what I can see) and I’m still facing the same error. I’ll share my screenshots in the hope we can detect where I’m going wrong.
When I run the ‘Make a Request’ module, rather than actually making the HTTP GET request successfully, I get this ‘Mappings’ message appearing, asking for an actual value in Column E. As if it doesn’t recognize the dynamic value mapping. I shouldn’t have to put a URL value. The ‘Make a Request’ module should automatically recognize the dynamic values mapped from column E. As you showed in your video.
If I continue by clicking OK on this message, I get the same error, which I assume is because it doesn’t see any value in Column E). The dynamic value mapping is not working:
@Harry2 That looks good. Can you let both run through again and then download the input of the HTTP module by clicking on this download symbol and sending it:
Apologies for the late reply. I realized where the issue is. When you write click on the ‘HTTP GET Request’ module, and run the module, this is where it displays the message window asking for a value for the URL, rather than taking dynamic URL values from the Google Sheet. Instead, I need to run the entire workflow from the ‘Run one’ button. This worked. This is the only way (at least from what I can see) for the HTTP GET request module to work, when dynamic URL values are fed to it from another data source (such as Google Sheets).
But well done to you. It’s by working with you and your questions that made me experiment and realize the issue.
I responded late because once I realized the fix, I wanted to then test your blueprint as well that you shared in the other post, and make sure it works for me, and in case I have any questions, before responding here.
Thank you for your help. I will mark this as resolved.
I have left you a few follow-up questions on the other post, regarding your blueprint. Many thanks
