Thanks . I used your code and steps , I think it's success - Here is the sample code and message from Pentaho - Can you pls give a sample to get data from Zuora just from 1 object example account - I want to read data from that object and store in SQL Server . ******************** #! C:\Users\abc\AppData\Local\Programs\Python\Python36-32\python.exe import httplib2 httplib2.debuglevel = 1 h = httplib2.Http('.cache') This is the python code which I used to connect to Zuora from Pentaho ************************************************************************* login_headers = {"Content-Type": "application/json","apiAccessKeyId": 'me.email@test.com', "apiSecretAccessKey": 'passwd',} services_login_url = "https://services999.zuora.com/apps/home.do" # login request resp, content = h.request(services_login_url, "POST", headers=login_headers) Z_access_cookie = resp["set-cookie"] update_headers = {"Content-Type": "application/json","Cookie": resp["set-cookie"]} print('ABCDEF') ************************************************************************* This is the result after running above code - Can any one explain if my code is able to connect to Zuora or not. 2018/06/06 19:57:27 - General - Logging plugin type found with ID: CheckpointLogTable 2018/06/06 19:57:40 - RepositoriesMeta - Reading repositories XML file: C:\Users\abcd\.kettle\repositories.xml 2018/06/06 19:57:47 - RepositoriesMeta - Reading repositories XML file: C:\Users\abcd\.kettle\repositories.xml 2018/06/06 19:57:57 - Carte - Installing timer to purge stale objects after 1440 minutes. 2018/06/06 19:58:22 - Spoon - Spoon 2018/06/06 19:58:54 - Spoon - Starting job... 2018/06/06 19:58:54 - testtest - Start of job execution 2018/06/06 19:58:54 - testtest - Starting entry [services_rest_login_snippet.py] 2018/06/06 19:58:54 - services_rest_login_snippet.py - Running on platform : Windows 7 2018/06/06 19:58:54 - services_rest_login_snippet.py - Executing command : cmd.exe /C "C:\Users\abcd\Desktop\Me\SQLServer\JE\Testing\services_rest_login_snippet.py" 2018/06/06 19:58:55 - services_rest_login_snippet.py - (stdout) connect: (services999.zuora.com, 443) 2018/06/06 19:58:55 - services_rest_login_snippet.py - (stdout) send: b'POST /apps/home.do HTTP/1.1\r\nHost: services999.zuora.com\r\nContent-Length: 0\r\ncontent-type: application/json\r\napiaccesskeyid: me.email@test.com\r\napisecretaccesskey: passwd\r\nuser-agent: Python-httplib2/0.11.3 (gzip)\r\naccept-encoding: gzip, deflate\r\n\r\n' 2018/06/06 19:58:55 - services_rest_login_snippet.py - (stdout) reply: 'HTTP/1.1 302 Found\r\n' 2018/06/06 19:58:55 - services_rest_login_snippet.py - (stdout) header: Content-Type header: Date header: Location header: Connection header: Set-Cookie header: Content-Length ABCDEF 2018/06/06 19:58:55 - testtest - Finished job entry [services_rest_login_snippet.py] (result=[true]) 2018/06/06 19:58:55 - testtest - Job execution finished 2018/06/06 19:58:55 - Spoon - Job has ended. **************************************************************************************************** If this is connecting to Zuora successfully , what are the next steps to start using API's to get data from account objects to a file. Can any one share some line of code here pls
... View more