Twitter API & Oauth verification

Does anyone know how to setup this query, or if it's even possible?

In HTTP Settings under JsonPathOnURL, I try:

Request Method: GET
Header: "Authorization"
Value: OAuth oauth_consumer_key="XXXX",oauth_token="YYYY",oauth_signature_method="HMAC-SHA1",oauth_timestamp="1472463665",oauth_nonce="xbhsNk",oauth_version="1.0",oauth_signature="ZZZZ"

Request Content Type: application/json

URL: https://api.twitter.com/1.1/friends/list.json?screen_name=heylissly
JsonPath: users.name

When I try to "Insert", I get the error: "Insert Formula Failed - See inner exception(s) for details".

The technique above works with Postman API Client. With this program, I don't select content type, but chose another Header: Content-Type: application/json.

The long string with Oauth settings, such as consumer key and access token, are generated with Postman, from the following settings page:

Here is the json results I am trying to extract information from:

Does anyone know what I'm going to do about this?

Thanks a lot!
/Victor

OAuth is not trivial to setup. I suggest you look at the Twitter Connector and try to modify this one to add the features you're missing.

If you do, please contribute on Github: https://github.com/nielsbosma/SeoTools-for-Excel-Connectors/blob/master/Twitter.xml