I have followed the steps which Jeff has explained in one of the links. However I am not getting the JSON output when I am calling the execute method and instead getting this error message "Request URI is not correct or null".
I believe you just need to add your URI query parameters into the component's properties. You'll then be able to supply them in the automation. You must call the SetURI...WithParameters method to supply them before calling Execute.
I have tried the way you have explained me by using seturiparameters, but getting below error instead of JSON. I have tried using Execute and ExecuteWithParameters method, both method is giving me below error.