Forum Discussion
Bad Request in Power Query
Hi Janki,
Please reffer to below link it has similar problem and it suggest to change the code a bit.
Existing Code
let
Source = Web.Contents(“https://api.twitter.com/1.1/search/tweets.json?q=PowerPivot”)
in
SourceNew Code
let
Source = Web.Contents(“https://api.twitter.com/1.1/search/tweets.json?q=PowerPivot&count=100″, [Headers=[#”Authorization”=”OAuth oauth_consumer_key=””YOURKEY””, oauth_nonce=””YOURCODE””, oauth_signature=””YOURSIGNATURE””, oauth_signature_method=””HMAC-SHA1″”, oauth_timestamp=””TIMESTAMP””, oauth_token=””YOURTOKEN””, oauth_version=””1.0″””]]
)
in
SourceHope this will help.
Regards
Gurpreet Sethi
let
Source = Json.Document(Web.Contents("https://api.twitter.com/1.1/trends/available.json&oauth_consumer_key=***&oauth_nonce=682713328&oauth_signature_method=HMAC-SHA1&oauth_signature=***&oauth_timestamp=1456461531&oauth_token=***&oauth_version=1.0"))
in
Source
Even getting error If i remove Json.Document() and only keep web.contents()
I am trying to pull the data as below request too
>> https://api.twitter.com/1.1/search/tweets.json?q=spotfire&count=100
BY
Ram
This started last Friday (March 4th, 2016). The only change event I can correlate this to is Salesforce Require Critical update on 3-4-2016: TLS 1.1 or higher for HTTPS connections.
Thanks for any suggestions to workaround.