Data360 Analyze

I would like to pull in data from the web via API. I was attempting to use the HTTP Node but it gives me an error that the URL cannot be converted to a URI. The same URL works within Power BI's Power Query for pulling data from the web. I want to do it this through Analyze so I can create a log of history rather than just pull fresh results. What is the best way to pull this data? I am using the freemium version of Analyze.

Are there any special characters in the URL that may need to be encoded?

Also, is the URL coming from a field? If so, was the URL property switched to From Field?

Thank you for the prompt response! I am entering the URL manually, and there was an encoding issue for " characters. I made the adjustment, and am now facing a new error related to my Header:

Unexpected error occurred during processAll while running the node: java.lang.IllegalArgumentException: Illegal header value provided: Authorization="Api-Token XXXXX".

Does this need encoded as well?

The header syntax should be:

Authorization: Api-Token XXXXX

That assumes Api-Token XXXXX is the syntax that your API endpoint expects to see the Authorization - this varies by endpoint.

Thank you Gerard, I am now able to pull data successfully!