Synchronous Analytics GET stats/accounts/:account_id api giving me unauthorised access

[sachin71421]

What i am doing -

first i am calling this api -
https://ads-api.twitter.com/3/accounts/18ce54om822/campaigns

and taking entity_id from above api - avc3z,avo2i,avqlt,aww2n

And, passing above entity_id to this api –

https://ads-api.twitter.com/3/stats/accounts/18ce54om822?end_time=2018-11-17&entity=ACCOUNT&entity_ids=avc3z,avo2i,avqlt,aww2n&granularity=TOTAL&metric_groups=ENGAGEMENT&placement=ALL_ON_TWITTER&start_time=2018-11-12

But it is giving me –

{“errors”:[{“code”:“UNAUTHORIZED_ACCESS”,“message”:“This request is not properly authenticated”}],“request”:{“params”:{}}}

FOR SIGNATURE –

1. preparing Oauthparameterstring like –

oauth_consumer_key="######"&oauth_nonce=6MlrXan5p1HU2INHKNXqBLHBqK4k818q&oauth_signature_method=HMAC-SHA1&oauth_timestamp=1532072472&oauth_token="#####"&oauth_version=1.0

2. Encoding BaseUrl —

https://ads-api.twitter.com/3/stats/accounts/18ce54om822
After encoding in UTF-8 -

https%3A%2F%2Fads-api.twitter.com%2F3%2Fstats%2Faccounts%2F18ce54om822

3. For Signature Base String Like —

GET&https%3A%2F%2Fads-api.twitter.com%2F3%2Fstats%2Faccounts%2F18ce54om822&

4. After that encoding ParameterString —

end_time=2018-11-17&entity=ACCOUNT&entity_ids=avc3z,avo2i,avqlt,aww2n&granularity=TOTAL&metric_groups=ENGAGEMENT&oauth_consumer_key=iLxfV4Ic6Wdn5DxBLXftkVjuC&oauth_nonce=6MlrXan5p1HU2INHKNXqBLHBqK4k818q&oauth_signature_method=HMAC-SHA1&oauth_timestamp=1532072472&oauth_token=849562846899970050-Xt9i3Fjooyj02j1H4nrbEBK93iWs5db&oauth_version=1.0&placement=ALL_ON_TWITTER&start_time=2018-11-12

After encoding ParameterString

end_time%3D2018-11-17%26entity%3DACCOUNT%26entity_ids%3Davc3z%2Cavo2i%2Cavqlt%2Caww2n%26granularity%3DTOTAL%26metric_groups%3DENGAGEMENT%26oauth_consumer_key%3DiLxfV4Ic6Wdn5DxBLXftkVjuC%26oauth_nonce%3D6MlrXan5p1HU2INHKNXqBLHBqK4k818q%26oauth_signature_method%3DHMAC-SHA1%26oauth_timestamp%3D1532072472%26oauth_token%3D849562846899970050-Xt9i3Fjooyj02j1H4nrbEBK93iWs5db%26oauth_version%3D1.0%26placement%3DALL_ON_TWITTER%26start_time%3D2018-11-12

5. Adding both the encoding Strings —

String encodedFinalSignatureBaseString = finalSignatureBaseString + encodedParameterString;

6. I am creating auth_signature using above details–

oauth_signature — ICwpwLjGdiLwm7XTnDY%2B1YxyHfw%3D

7. At last, I am calling Api Using Unirest —

URL ---- https://ads-api.twitter.com/3/stats/accounts/18ce54om822?end_time=2018-11-17&entity=ACCOUNT&entity_ids=avc3z,avo2i,avqlt,aww2n&granularity=TOTAL&metric_groups=ENGAGEMENT&placement=ALL_ON_TWITTER&start_time=2018-11-12

“Authorization”, “OAuth oauth_consumer_key=”####",oauth_nonce=“6MlrXan5p1HU2INHKNXqBLHBqK4k818q”,oauth_signature="#########",oauth_signature_method=“HMAC-SHA1”,oauth_timestamp=“1532072472”,oauth_token="#########",oauth_version=“1.0”

After All process it is giving me error.
Please help me on this
Thanx

[majoritasdev]

@sachin71421: the oauth signature should end in =, not in %3D.

[sachin71421]

but other API is working fine.

[majoritasdev]

…I don’t know… I’m just telling you what the docs say… https://developer.twitter.com/en/docs/basics/authentication/guides/creating-a-signature. At the bottom of the page, they reach a value of hCtSmYh+iHYCEqBWrE7C7hYmtUk=, which ends in =, not %3D.

Just try it and see if it works.

[sachin71421]

Yes, I have tried with this also but still facing problem

[sachin71421]

See this is my code Please Check once ----

        String oauthParameterString = "oauth_consumer_key" + '=' + consumerKey + '&' + "oauth_nonce" + '=' + oauth_nonce + '&' + "oauth_signature_method" + '=' + oauth_signature_method +
            '&' + "oauth_timestamp" + '=' + oauth_timestamp + '&' + "oauth_token" + '=' + oauthToken + '&' + "oauth_version" + '=' + oauth_version;
        
        String finalParameterString =  param1 +'&' +oauthParameterString+param2;
        String encodedParameterString = URLEncoder.encode(finalParameterString, "UTF-8");
        
        encodedParameterString = encodedParameterString.replaceAll("%", "%25");
        String encodedBaseUrl = URLEncoder.encode(baseURL, "UTF-8");    
        String finalSignatureBaseString = method + '&' + encodedBaseUrl + '&';
        
        
        
        String encodedFinalSignatureBaseString = finalSignatureBaseString + encodedParameterString;
        
        String signingKey = URLEncoder.encode(consumerSecret, "UTF-8") + "&" + URLEncoder.encode(authTokenSecret, "UTF-8");
        
        SecretKeySpec finalSigningKey = new SecretKeySpec(signingKey.getBytes(), "HmacSHA1");
        Mac mac = Mac.getInstance(finalSigningKey.getAlgorithm());
        
        mac.init(finalSigningKey);
        byte[] rawHmac = mac.doFinal(encodedFinalSignatureBaseString.getBytes());
        String base64String = BaseEncoding.base64().encode(rawHmac);
        base64String = base64String.replace("+", "%2B");
        base64String = base64String.replace("=", "%3D");
        base64String = base64String.replace("/", "%2F");
        return base64String;

[sachin71421]

String param1 =“end_time=2018-11-18&entity=ACCOUNT&entity_ids=avc3z,avo2i,avqlt,aww2n&granularity=TOTAL&metric_groups=MEDIA,ENGAGEMENT,BILLING,LIFE_TIME_VALUE_MOBILE_CONVERSION”

String param2="&placement=ALL_ON_TWITTER&start_time=2018-11-13";

String baseURL=“https://ads-api.twitter.com/3/stats/accounts/18ce54om822”;

String method=“GET”;

String oauthToken="***"
String consumerSecret="***"
String authTokenSecret="***"
String consumerKey="***"
Long oauth_timestamp= System.currentTimeMillis() / 1000;

Please check this one also

[abraham]

I would recommend finding an established OAuth library and using that. Trying to roll your own is almost impossible.

[sachin71421]

Hi @abraham and @majoritasdev ,

Now it is working but if i am passing one values inside querry parameter strings like -

https://ads-api.twitter.com/3/stats/accounts/18ce54om822?end_time=2018-11-19&entity=ACCOUNT&entity_ids=avc3z,avo2i,avqlt,aww2n&granularity=TOTAL&metric_groups=BILLING,ENGAGEMENT&placement=ALL_ON_TWITTER&start_time=2018-11-14

it is showing error but when i am pass one parameters like -

https://ads-api.twitter.com/3/stats/accounts/18ce54om822?end_time=2018-11-19&entity=ACCOUNT&entity_ids=avc3z&granularity=TOTAL&metric_groups=ENGAGEMENT&placement=ALL_ON_TWITTER&start_time=2018-11-14

then it is working

it is resolved. Actually, I think encoding is not correct that’s way the problem comming
i can do my working but if you tell me how to encode prperly that would be good.

Thanx for your help.