I am attempting to build a HTTPAPI application to a Google Doc's spreadsheet. Th e process, as defined by Google, requires a published spreadsheet, getting an au thorization token and XML data block to POST to the link URL I am seeing a 403 forbidden error in the log and wondering if that is from Googl e or I am being blocked by my local server? I have included a copy of the debug log and a program listing. Thanks! -- Dave Hanneman | Technical Analyst III, Warehouse Business Systems | RR Donnelley 3075 Highland Avenue | Downers Grove, IL 60515 Office: 630.322.6420 [1]dave.c.hanneman@xxxxxxx [2]http://www.rrdonnelley.com References 1. mailto:dave.c.hanneman@xxxxxxx 2. http://www.rrdonnelley.com/
ÿþ 5 7 6 1 W D S V 6 R 1 M 0 0 8 0 2 1 5 S E U S O U R C E L I S T I N G 0 8 / 1 5 / 1 2 1 2 : 1 0 : 3 6 C O R P D E V 2 P A G E 1
S O U R C E F I L E . . . . . . . L I B H T T P / Q R P G L E S R C
M E M B E R . . . . . . . . . G O O G L E T
S E Q N B R * . . . + . . . 1 . . . + . . . 2 . . . + . . . 3 . . . + . . . 4 . . . + . . . 5 . . . + . . . 6 . . . + . . . 7 . . . + . . . 8 . . . + . . . 9 . . . + . . . 0
1 0 0 H D F T A C T G R P ( * N O ) A C T G R P ( * N E W ) B N D D I R ( ' H T T P A P I ' ) 0 8 / 1 4 / 1 2
2 0 0 / d e f i n e W E B F O R M S 0 8 / 1 4 / 1 2
3 0 0 D / c o p y q r p g l e s r c , h t t p a p i _ h 0 8 / 1 4 / 1 2
4 0 0 D c m d p r e x t p g m ( ' Q C M D E X C ' ) 0 8 / 1 4 / 1 2
5 0 0 D c o m m a n d 2 0 0 A c o n s t 0 8 / 1 4 / 1 2
6 0 0 D l e n g t h 1 5 P 5 c o n s t 0 8 / 1 4 / 1 2
7 0 0 D r c s 1 0 I 0 0 8 / 1 4 / 1 2
8 0 0 D m s g s 5 2 A 0 8 / 1 4 / 1 2
9 0 0 D C R L F C C O N S T ( x ' 0 d 2 5 ' ) 0 8 / 1 4 / 1 2
1 0 0 0 D d a t a S 1 0 2 4 A 0 8 / 1 4 / 1 2
1 1 0 0 D Q Q C C O N S T ( x ' 7 F ' ) Q u o t e L i t e r a l 0 8 / 1 4 / 1 2
1 2 0 0 D A T O M C C O N S T ( ' h t t p : / / w w w . w 3 . o r g / 2 0 0 5 / A t o m ' ) 0 8 / 1 4 / 1 2
1 3 0 0 D S C H E M A C C O N S T ( ' h t t p : / / s c h e m a s . g o o g l e . c o m . s p r + 0 8 / 1 4 / 1 2
1 4 0 0 D e a d s h e e t s / 2 0 0 6 / e x t e n d e d ' ) 0 8 / 1 4 / 1 2
1 5 0 0 D F o r m s l i k e ( W E B F O R M ) 0 8 / 1 4 / 1 2
1 6 0 0 D a c c o u n t T y p e s 1 0 0 A v a r y i n g 0 8 / 1 4 / 1 2
1 7 0 0 D E m a i l s 1 0 0 A v a r y i n g 0 8 / 1 4 / 1 2
1 8 0 0 D P a s s w d s 1 0 0 A v a r y i n g 0 8 / 1 4 / 1 2
1 9 0 0 D s e r v i c e s 1 0 0 A v a r y i n g 0 8 / 1 4 / 1 2
2 0 0 0 D s o u r c e s 1 0 0 A v a r y i n g 0 8 / 1 4 / 1 2
2 1 0 0 D m y P o i n t e r s * 0 8 / 1 4 / 1 2
2 2 0 0 D d a t a S i z e s 1 0 I 0 0 8 / 1 4 / 1 2
2 3 0 0 0 8 / 1 4 / 1 2
2 4 0 0 d P a r s e A u t h p r 1 0 i 0 0 8 / 1 4 / 1 2
2 5 0 0 d d e s c r i p t o r 1 0 i 0 0 8 / 1 4 / 1 2
2 6 0 0 d d a t a 8 1 9 2 a o p t i o n s ( * v a r s i z e ) 0 8 / 1 4 / 1 2
2 7 0 0 d d a t a L e n 1 0 i 0 v a l u e 0 8 / 1 4 / 1 2
2 8 0 0 d a u t h S t r i n g s 8 1 9 2 a v a r y i n g 0 8 / 1 4 / 1 2
2 9 0 0 c c a l l p h t t p _ d e b u g ( * O N ) 0 8 / 1 5 / 1 2
3 0 0 0 / f r e e 0 8 / 1 4 / 1 2
3 1 0 0 a c c o u n t T y p e = ' H O S T E D ' ; 0 8 / 1 5 / 1 2
3 2 0 0 E m a i l = ' d a v e . c . h a n n e m a n @ r r d . c o m ' ; 0 8 / 1 4 / 1 2
3 3 0 0 P a s s w d = ' * * * * * * * * ' ; 0 8 / 1 5 / 1 2
3 4 0 0 s e r v i c e = ' w i s e ' ; 0 8 / 1 4 / 1 2
3 5 0 0 s o u r c e = ' R R D - O r d e r R e d i r e c t - 1 . 0 0 ' ; 0 8 / 1 4 / 1 2
3 6 0 0 0 8 / 1 4 / 1 2
3 7 0 0 F o r m = W E B F O R M _ o p e n ( ) ; 0 8 / 1 4 / 1 2
3 8 0 0 0 8 / 1 4 / 1 2
3 9 0 0 W E B F O R M _ S e t V a r ( F o r m : ' a c c o u n t T y p e ' : a c c o u n t T y p e ) ; 0 8 / 1 4 / 1 2
4 0 0 0 W E B F O R M _ S e t V a r ( F o r m : ' E m a i l ' : E m a i l ) ; 0 8 / 1 4 / 1 2
4 1 0 0 W E B F O R M _ S e t V a r ( F o r m : ' P a s s w d ' : P a s s w d ) ; 0 8 / 1 4 / 1 2
4 2 0 0 W E B F O R M _ S e t V a r ( F o r m : ' s e r v i c e ' : s e r v i c e ) ; 0 8 / 1 4 / 1 2
4 3 0 0 W E B F O R M _ S e t V a r ( F o r m : ' s o u r c e ' : s o u r c e ) ; 0 8 / 1 4 / 1 2
4 4 0 0 W E B F O R M _ p o s t D a t a ( F o r m : m y P o i n t e r : d a t a S i z e ) ; 0 8 / 1 4 / 1 2
4 5 0 0 0 8 / 1 4 / 1 2
4 6 0 0 r c = h t t p _ u r l _ p o s t _ r a w ( 0 8 / 1 4 / 1 2
4 7 0 0 ' h t t p s : / / w w w . g o o g l e . c o m / a c c o u n t s / C l i e n t L o g i n ' 0 8 / 1 4 / 1 2
4 8 0 0 : m y P o i n t e r 0 8 / 1 4 / 1 2
4 9 0 0 : d a t a S i z e 0 8 / 1 4 / 1 2
5 0 0 0 : 1 0 8 / 1 4 / 1 2
5 1 0 0 : % p a d d r ( ' P A R S E A U T H ' ) 0 8 / 1 4 / 1 2
5 2 0 0 : H T T P _ T I M E O U T 0 8 / 1 4 / 1 2
5 3 0 0 : H T T P _ U S E R A G E N T 0 8 / 1 4 / 1 2
5 7 6 1 W D S V 6 R 1 M 0 0 8 0 2 1 5 S E U S O U R C E L I S T I N G 0 8 / 1 5 / 1 2 1 2 : 1 0 : 3 6 C O R P D E V 2 P A G E 2
S O U R C E F I L E . . . . . . . L I B H T T P / Q R P G L E S R C
M E M B E R . . . . . . . . . G O O G L E T
S E Q N B R * . . . + . . . 1 . . . + . . . 2 . . . + . . . 3 . . . + . . . 4 . . . + . . . 5 . . . + . . . 6 . . . + . . . 7 . . . + . . . 8 . . . + . . . 9 . . . + . . . 0
5 4 0 0 : ' a p p l i c a t i o n / x - w w w - f o r m - u r l e n c o d e d ' ) ; 0 8 / 1 4 / 1 2
5 5 0 0 0 8 / 1 4 / 1 2
5 6 0 0 i f r c < > 1 ; 0 8 / 1 4 / 1 2
5 7 0 0 m s g = h t t p _ e r r o r ; 0 8 / 1 4 / 1 2
5 8 0 0 d s p l y m s g ; 0 8 / 1 4 / 1 2
5 9 0 0 e l s e ; 0 8 / 1 4 / 1 2
6 0 0 0 d a t a = ' x m l n s = ' + Q Q + A T O M + Q Q + ' x m l n s : g s x ' + Q Q + S C H E M A + Q Q + 0 8 / 1 4 / 1 2
6 1 0 0 ' < g s x : O r i g i n a l W a r e h o u s e > 0 0 5 0 < / g s x : O r i g i n a l W a r e h o u s e > ' + 0 8 / 1 4 / 1 2
6 2 0 0 ' < g s x : O r d e r N u m b e r > 1 1 1 1 1 1 1 1 < / g s x : O r d e r N u m b e r > ' + 0 8 / 1 4 / 1 2
6 3 0 0 ' < g s x : O r d e r S u f f i x > 2 2 2 2 < / g s x : O r d e r S u f f i x > ' + 0 8 / 1 4 / 1 2
6 4 0 0 ' < g s x : L i n e > 0 0 0 0 2 < / g s x : L i n e > ' + 0 8 / 1 4 / 1 2
6 5 0 0 ' < g s x : I t e m N u m b e r > I T M 0 0 5 0 < / g s x : I t e m N u m b e r > ' + 0 8 / 1 4 / 1 2
6 6 0 0 ' < g s x : Q u a n t i t y t o r e d i r e c t > 5 0 0 < / g s x : Q u a n t i t y t o r e d i r e c t > ' + 0 8 / 1 4 / 1 2
6 7 0 0 ' < g s x : T a r g e t W a r e h o u s e > 0 0 3 4 < / g s x : T a r g e t W a r e h o u s e > ' + 0 8 / 1 4 / 1 2
6 8 0 0 ' < g s x : C o r p o r a t e C u s t o m e r > 1 2 3 6 5 4 7 8 0 9 < / g s x : C o r p o r a t e C u s t o m e r > ' + 0 8 / 1 4 / 1 2
6 9 0 0 ' < g s x : N a m e > T C P U S E R < / g s x : N a m e > ' + 0 8 / 1 4 / 1 2
7 0 0 0 ' < g s x : E m p l o y e e I D > T C P U S E R < / g s x : E m p l o y e e I D > ' ; 0 8 / 1 4 / 1 2
7 1 0 0 0 8 / 1 4 / 1 2
7 2 0 0 r c = h t t p _ u r l _ p o s t ( ' h t t p s : / / d o c s . g o o g l e . c o m / a / r r d . c o m / s p r e a d s h e e t / c + 0 8 / 1 4 / 1 2
7 3 0 0 c c ? k e y = 0 A m 0 r k V 7 D t o h p d G R w a G 4 3 Y 2 x i O W R m a z F Y e U d q X 3 B + 0 8 / 1 4 / 1 2
7 4 0 0 R Z m c ' 0 8 / 1 4 / 1 2
7 5 0 0 : % a d d r ( d a t a ) 0 8 / 1 4 / 1 2
7 6 0 0 : % l e n ( % t r i m r ( d a t a ) ) 0 8 / 1 4 / 1 2
7 7 0 0 : ' / t m p / h t t p t e s t . h t m l ' ) ; 0 8 / 1 4 / 1 2
7 8 0 0 i f r c < > 1 ; 0 8 / 1 4 / 1 2
7 9 0 0 m s g = h t t p _ e r r o r ; 0 8 / 1 4 / 1 2
8 0 0 0 d s p l y m s g ; 0 8 / 1 4 / 1 2
8 1 0 0 r e t u r n ; 0 8 / 1 4 / 1 2
8 2 0 0 e n d i f ; 0 8 / 1 4 / 1 2
8 3 0 0 e n d i f ; 0 8 / 1 4 / 1 2
8 4 0 0 / e n d - f r e e 0 8 / 1 4 / 1 2
8 5 0 0 c c a l l p c m d ( ' D S P F ' ' / t m p / h t t p t e s t . h t m l ' ' ' : 2 0 0 ) 0 8 / 1 4 / 1 2
8 6 0 0 c e v a l * i n l r = * o n 0 8 / 1 4 / 1 2
8 7 0 0 c r e t u r n 0 8 / 1 4 / 1 2
8 8 0 0 p P a r s e A u t h b 0 8 / 1 4 / 1 2
8 9 0 0 d P a r s e A u t h p i 1 0 i 0 0 8 / 1 4 / 1 2
9 0 0 0 d d e s c r i p t o r 1 0 i 0 0 8 / 1 4 / 1 2
9 1 0 0 d d a t a 8 1 9 2 a o p t i o n s ( * v a r s i z e ) 0 8 / 1 4 / 1 2
9 2 0 0 d d a t a L e n 1 0 i 0 v a l u e 0 8 / 1 4 / 1 2
9 3 0 0 0 8 / 1 4 / 1 2
9 4 0 0 d s t a r t S I D s 1 0 i 0 0 8 / 1 4 / 1 2
9 5 0 0 d s t a r t L S I D s 1 0 i 0 0 8 / 1 4 / 1 2
9 6 0 0 d s t a r t A u t h s 1 0 i 0 0 8 / 1 4 / 1 2
9 7 0 0 / f r e e 0 8 / 1 4 / 1 2
9 8 0 0 s t a r t S I D = % s c a n ( ' S I D = ' : d a t a ) ; 0 8 / 1 4 / 1 2
9 9 0 0 s t a r t L S I D = % s c a n ( ' L S I D = ' : d a t a : s t a r t S I D ) ; 0 8 / 1 4 / 1 2
1 0 0 0 0 s t a r t A u t h = % s c a n ( ' A u t h = ' : d a t a : s t a r t L S I D ) ; 0 8 / 1 4 / 1 2
1 0 1 0 0 A u t h S t r i n g = % s u b s t ( d a t a : s t a r t A u t h ) ; 0 8 / 1 4 / 1 2
1 0 2 0 0 r e t u r n 1 ; 0 8 / 1 4 / 1 2
1 0 3 0 0 / e n d - f r e e 0 8 / 1 4 / 1 2
1 0 4 0 0 p P a r s e A u t h e 0 8 / 1 4 / 1 2
* * * * E N D O F S O U R C E * * * *
HTTPAPI Ver 1.23 released 2008-04-24 OS/400 Ver V6R1M0 New iconv() objects set, PostRem=819. PostLoc=0. ProtRem=819. ProtLoc=0 http_persist_open(): entered http_long_ParseURL(): entered DNS resolver retrans: 2 DNS resolver retry : 2 DNS resolver options: x'00000136' DNS default domain: RRD.COM DNS server found: 162.27.8.186 DNS server found: 172.24.8.126 DNS server found: 172.24.14.21 https_init(): entered ------------------------------------------------------------------------------------- Dump of local-side certificate information: ------------------------------------------------------------------------------------- -----BEGIN CERTIFICATE----- MIIDkjCCAnqgAwIBAgIHUCE4pw6BsDANBgkqhkiG9w0BAQUFADCBizELMAkGA1UE BhMCVVMxETAPBgNVBAgTCElsbGlub2lzMRYwFAYDVQQHEw1Eb3duZXJzIEdyb3Zl MSMwIQYDVQQKExpXYXJlaG91c2UgQnVzaW5lc3MgU3lzdGVtczEMMAoGA1UECxMD V0JTMR4wHAYDVQQDExVDT1JQREVWMiBSUkQgTG9jYWwgQ0EwHhcNMTIwODA2MTU0 NzUxWhcNMTgwMTI4MTU0NzUxWjCBhjELMAkGA1UEBhMCVVMxETAPBgNVBAgTCEls bGlub2lzMRYwFAYDVQQHEw1Eb3duZXJzIEdyb3ZlMSMwIQYDVQQKExpXYXJlaG91 c2UgQnVzaW5lc3MgU3lzdGVtczEMMAoGA1UECxMDV0JTMRkwFwYDVQQDExBDb3Jw ZGV2Mi5ycmQuY29tMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsvmn ECgsSyoP9D6iXmHJDJrUijBba/tEDes6tIdfAeB+Al6sdL5Xh74kj6ykTChlpYSu yy8T1eWfUPDVk7zPYe/L53KfSQ6ky6Z8GvQntDQpqsq/2omgHTJfkxmcM4BxTP3o 9pzIC4aEAiqkT3wO/PwfBEweQzXzDtP5GJS8A2PfACR2H/vY+HonxiWRII121rkq hkpJXJ0++5Akq86ENfJghT+lpswzbkT0Qr3uUmLAVEXFzeBvOgCT4lYWV6hyNd5g t26WcGq4yIQDhUvixMeMm9n8z9K5oma7vc72qoJw27H/tOqTBOEbqF4Y1peEH/0m n6anknTOlLcD6qsPKQIDAQABMA0GCSqGSIb3DQEBBQUAA4IBAQBuSvEAG2Mb3orN zIKl4vcHOl7+NardlJ6kss+78V2QeCg58ICpZdO26n9L0bMcCBrL2Pr2WMvqXsWo LK5HvVDxDAr64zgISvfg5FyjRxGNDQjmAhJThgzlvgm4EKaYpK1gqVdblSB7eorV ygv43A66XHyNjAO3tZbT0C8/IWagGyolQxYJK1B9gyq4GX8uARDqEtw9BtOMuk53 kTA0nuAKylTTsBYmvjrl5S6b7b8pCtfPsd+936YaRSzDioRhs7NAhfMl91oSXrAO DuWIvuL2ickKNlbkuV5J5gzj/UHMS+8gOCTBvNRHnOhaxIy/1v3FjYdJeLfAXEqE zYYCu5+2 -----END CERTIFICATE----- Serial Number: 50:21:38:A7:0E:81:B0 Common Name: Corpdev2.rrd.com Country: US State/Province: Illinois Locality: Downers Grove Org Unit: Warehouse Business Systems Org: WBS Issuer CN: CORPDEV2 RRD Local CA Issuer Country: US Issuer State/Province: Illinois Issuer Locality: Downers Grove Issuer Org: Warehouse Business Systems Issuer Org Unit: WBS Version: 03 not before: 20120806104751 not after: 20180128094751 pub key alg: 1.2.840.113549.1.1.5 ------------------------------------------------------------------------------------- Dump of server-side certificate information: ------------------------------------------------------------------------------------- Cert Validation Code = 0 -----BEGIN CERTIFICATE----- MIIDITCCAoqgAwIBAgIQT52W2WawmStUwpV8tBV9TTANBgkqhkiG9w0BAQUFADBM MQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkg THRkLjEWMBQGA1UEAxMNVGhhd3RlIFNHQyBDQTAeFw0xMTEwMjYwMDAwMDBaFw0x MzA5MzAyMzU5NTlaMGgxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpDYWxpZm9ybmlh MRYwFAYDVQQHFA1Nb3VudGFpbiBWaWV3MRMwEQYDVQQKFApHb29nbGUgSW5jMRcw FQYDVQQDFA53d3cuZ29vZ2xlLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkC gYEA3rcmQ6aZhc04pxUJuc8PycNVjIjujI0oJyRLKl6g2Bb6YRhLz21ggNM1QDJy wI8S2OVOj7my9tkVXlqGMaO6hqpryNlxjMzNJxMenUJdOPanrO/6YvMYgdQkRn8B d3zGKokUmbuYOR2oGfs5AER9G5RqeC1prcB6LPrQ2iASmNMCAwEAAaOB5zCB5DAM BgNVHRMBAf8EAjAAMDYGA1UdHwQvMC0wK6ApoCeGJWh0dHA6Ly9jcmwudGhhd3Rl LmNvbS9UaGF3dGVTR0NDQS5jcmwwKAYDVR0lBCEwHwYIKwYBBQUHAwEGCCsGAQUF BwMCBglghkgBhvhCBAEwcgYIKwYBBQUHAQEEZjBkMCIGCCsGAQUFBzABhhZodHRw Oi8vb2NzcC50aGF3dGUuY29tMD4GCCsGAQUFBzAChjJodHRwOi8vd3d3LnRoYXd0 ZS5jb20vcmVwb3NpdG9yeS9UaGF3dGVfU0dDX0NBLmNydDANBgkqhkiG9w0BAQUF AAOBgQAhrNWuyjSJWsKrUtKyNGadeqvu5nzVfsJcKLt0AMkQH0IT/GmKHiSgAgDp ulvKGQSy068Bsn5fFNum21K5mvMSf3yinDtvmX3qUA12IxL/92ZzKbeVCq3Yi7Le IOkKcGQRCMha8X2e7GmlpdWC1ycenlbN0nbVeSv3JUMcafC4+Q== -----END CERTIFICATE----- Serial Number: 4F:9D:96:D9:66:B0:99:2B:54:C2:95:7C:B4:15:7D:4D Common Name: www.google.com Country: US State/Province: California Locality: Mountain View Org Unit: Google Inc Issuer CN: Thawte SGC CA Issuer Country: ZA Issuer Org: Thawte Consulting (Pty) Ltd. Version: 03 not before: 20111025190000 not after: 20130930185959 pub key alg: 1.2.840.113549.1.1.5 Protocol Used: TLS Version 1 http_persist_post(): entered http_long_ParseURL(): entered do_post(): entered POST /accounts/ClientLogin HTTP/1.1 Host: www.google.com User-Agent: http-api/1.23 Content-Type: application/x-www-form-urlencoded Expect: 100-continue Content-Length: 119 recvresp(): entered SetError() #43: CommSSL_Read: time-out! senddoc(): entered accountType=HOSTED&Email=dave.c.hanneman%40rrd.com&Passwd=********++++++++++&service=wise&source=RRD-OrderRedirect-1.00 recvresp(): entered HTTP/1.1 403 Forbidden Content-Type: text/plain Cache-control: no-cache, no-store Pragma: no-cache Expires: Mon, 01-Jan-1990 00:00:00 GMT Date: Wed, 15 Aug 2012 16:45:27 GMT X-Content-Type-Options: nosniff X-XSS-Protection: 1; mode=block Content-Length: 24 Server: GSE SetError() #13: HTTP/1.1 403 Forbidden recvdoc parms: identity 24 header_load_cookies() entered recvdoc(): entered SetError() #0: Error=BadAuthentication
----------------------------------------------------------------------- This is the FTPAPI mailing list. To unsubscribe, please go to: http://www.scottklement.com/mailman/listinfo/ftpapi -----------------------------------------------------------------------