
ColdFusion Private application OAuth Access
Has anyone successfully accessed a Private Application using ColdFusion?
Any information or direction is appreciated.
kind regards
Mat.
Any information or direction is appreciated.
kind regards
Mat.
10
Replies

To answer my own question, ColdFusion can use the Java example. ColdFusion is simply a scripting language on top of Java.

Hi Matthew - Is there any chance you could share your solution in detail? I'm currently having issues trying to get this working.

If anyone has a solution, could you please provide a snippet or two? Problems I'm having specifically are with the RSA-SHA1 requirement. Be good to see how you guys have solved it.

I finally found the solution and it is detailed very well here:
Coldfusion oAuth with Xero
After getting the signing right the Xero API was reporting back that it couldn't verify my signature because the CER file (public key) upload section in api.xero.com doesn't seem to work. I had to cut and paste the actual base64 encoded string (minus the first and last lines) and then save it.
I'm happy to help anyone who needs more clarification - just reply here.
Coldfusion oAuth with Xero
After getting the signing right the Xero API was reporting back that it couldn't verify my signature because the CER file (public key) upload section in api.xero.com doesn't seem to work. I had to cut and paste the actual base64 encoded string (minus the first and last lines) and then save it.
I'm happy to help anyone who needs more clarification - just reply here.

Hey Guy, that's great. Actually, that was my thread on Stackoverflow. I got as far as returning results for specified customerIds, but as soon as I tried to pass other filters in the url, I got a signature error.
This works to return a single record with specified ContactID:
https://api.xero.com/api.xro/ 2.0/Contacts/dbb1f0b5-a71b- 4458-8462-104acd0fec6b?oauth_ consumer_key= 8HAG3BJ90JQUALKYEANCZLQAYCJUJQ &oauth_nonce= 3BD98C163B7FFF9F0A2997FDF9C476 BBD51E9930&oauth_signature= K3jbnc5SUBR% 2BhnyxpanVSfJMQWsJrAweD7ZN7Ofh %2Bf4T0QTsWE6yXarOnVWF8s7D% 2BIb% 2FZloYPEjvagkCNSMruf7GwcwgHxJ9 HpyVFQR6SXg% 2BxS0JwOOgUhKgrAHWZ367urbwlvD9 kwUceFHv8O4loMhlYYwgHWavlniBk% 2BQJ%2FYM%3D&oauth_signature_ method=RSA-SHA1&oauth_ timestamp=1339448382&oauth_ token= 8HAG3BJ90JQUALKYEANCZLQAYCJUJQ &oauth_version=1.0
This tells me to take a hike ("Failed to Validate Signature")
https://api.xero.com/api.xro/ 2.0/Contacts/dbb1f0b5-a71b- 4458-8462-104acd0fec6b?where= Name.Contains("xero")&order= Name&oauth_consumer_key= 8HAG3BJ90JQUALKYEANCZLQAYCJUJQ &oauth_nonce= 766F53F0B3A69E1A212FA261B60955 566B241400&oauth_signature= AFAEWgl% 2BxQP9BxmNGnXEyw7ZsFcaYral0% 2F%2Fe3VPm% 2BkbSIJl1ckvA8bHqOB1% 2B097BxAUqjN8rtTz6xmRRYMx2% 2Fa2n%2BuFv02dCz654GZn9AFJ% 2Bmg68UipD74dViuL3mjRviokEwygM MBahGuPNi9Dw0pYXs8wMWLyXfpfPOl q8UPk%3D&oauth_signature_ method=RSA-SHA1&oauth_ timestamp=1339447897&oauth_ token= 8HAG3BJ90JQUALKYEANCZLQAYCJUJQ &oauth_version=1.0
If you have resolved passing various filters, would you mind posting or emailing me at paulbaylis1 at yahoo dot com?
This works to return a single record with specified ContactID:
https://api.xero.com/api.xro/ 2.0/Contacts/dbb1f0b5-a71b- 4458-8462-104acd0fec6b?oauth_ consumer_key= 8HAG3BJ90JQUALKYEANCZLQAYCJUJQ &oauth_nonce= 3BD98C163B7FFF9F0A2997FDF9C476 BBD51E9930&oauth_signature= K3jbnc5SUBR% 2BhnyxpanVSfJMQWsJrAweD7ZN7Ofh %2Bf4T0QTsWE6yXarOnVWF8s7D% 2BIb% 2FZloYPEjvagkCNSMruf7GwcwgHxJ9 HpyVFQR6SXg% 2BxS0JwOOgUhKgrAHWZ367urbwlvD9 kwUceFHv8O4loMhlYYwgHWavlniBk% 2BQJ%2FYM%3D&oauth_signature_ method=RSA-SHA1&oauth_ timestamp=1339448382&oauth_ token= 8HAG3BJ90JQUALKYEANCZLQAYCJUJQ &oauth_version=1.0
This tells me to take a hike ("Failed to Validate Signature")
https://api.xero.com/api.xro/ 2.0/Contacts/dbb1f0b5-a71b- 4458-8462-104acd0fec6b?where= Name.Contains("xero")&order= Name&oauth_consumer_key= 8HAG3BJ90JQUALKYEANCZLQAYCJUJQ &oauth_nonce= 766F53F0B3A69E1A212FA261B60955 566B241400&oauth_signature= AFAEWgl% 2BxQP9BxmNGnXEyw7ZsFcaYral0% 2F%2Fe3VPm% 2BkbSIJl1ckvA8bHqOB1% 2B097BxAUqjN8rtTz6xmRRYMx2% 2Fa2n%2BuFv02dCz654GZn9AFJ% 2Bmg68UipD74dViuL3mjRviokEwygM MBahGuPNi9Dw0pYXs8wMWLyXfpfPOl q8UPk%3D&oauth_signature_ method=RSA-SHA1&oauth_ timestamp=1339447897&oauth_ token= 8HAG3BJ90JQUALKYEANCZLQAYCJUJQ &oauth_version=1.0
If you have resolved passing various filters, would you mind posting or emailing me at paulbaylis1 at yahoo dot com?

hello there, any news on a solution here did anyone get it working correctly?

Hi pcw pcw, I have it working fine - what specifically are you having issues with?

Hi Guy,
Its an authentication issue, any chance you could email me some example code including the actual call to the xero api to stuartcalderpcw@yahoo.co.uk please
Its an authentication issue, any chance you could email me some example code including the actual call to the xero api to stuartcalderpcw@yahoo.co.uk please

cant get passed your original error Guy, did u have to pasted the cer to get the signature to work ? this is the call im using to get the signature generated
GET&https%3A%2F%2Fapi%2Exero%2Ecom%2Fapi%2Exro%2F2%2E0%2FItems&oauth%5Fconsumer%5Fkey%3DBSXW5ACNOKVLCESJMTWSGFMA9M1DLI%26oauth%5Fnonce%3D6605878388206195597%26oauth%5Fsignature%5Fmethod%3DRSA%2DSHA1%26oauth%5Ftimestamp%3D1390410209%26oauth%5Ftoken%3DBSXW5ACNOKVLCESJMTWSGFMA9M1DLI%26oauth%5Fversion%3D1%2E0
GET&https%3A%2F%2Fapi%2Exero%2Ecom%2Fapi%2Exro%2F2%2E0%2FItems&oauth%5Fconsumer%5Fkey%3DBSXW5ACNOKVLCESJMTWSGFMA9M1DLI%26oauth%5Fnonce%3D6605878388206195597%26oauth%5Fsignature%5Fmethod%3DRSA%2DSHA1%26oauth%5Ftimestamp%3D1390410209%26oauth%5Ftoken%3DBSXW5ACNOKVLCESJMTWSGFMA9M1DLI%26oauth%5Fversion%3D1%2E0

This works for me: https://gist.github.com/mjb/8567585
Feedback welcome.
Feedback welcome.