Hello Chi, I have compression as "none" and no encryption. This is what I have so far (this is NetSuite using JavaScript): var header = {"Content-Type": "application/json", "Authorization": "Bearer " + BEARER_TOKEN, "Accept": "*/*"};
var requestURL = "https://rest.apisandbox.zuora.com/query/jobs";
var body = JSON.stringify({"compression": "NONE", "output": {"target": "S3"}, "outputFormat": "JSON", "query": "select * from user"});
postResponse = https.post({url: requestURL, headers: header, body: body});
var responseBody = JSON.parse(postResponse.body);
var responseID = responseBody.data.id;
requestURL = requestURL + "/" + responseID;
var getResponse = https.get({url: requestURL, headers: header});
var getResponseBody = JSON.parse(getResponse.body);
var dataFileURL = JSON.parse(getResponse.body).data.dataFile;
var dataFileResponse = https.get({url: dataFileURL}); the dataFileURL comes back as: https://owl-auw2-sbx01-query-result.s3.us-west-2.amazonaws.com/dd861ce5-e71c-4a2f-9c90-_7558915210100413.jsonl?X-Amz-Security-Token=LXdlc3QtMiJIMEYCIQCXpkMMleoYK1nRVR2PDbIudNTqMQj3b7wykRj2Rarj%2FAIhAKDIER%2FIFJZ9WlIJ7p%2F%2BQAIxAmqNgUrk6uA8X9rqCYAyKvUDCI3%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQAhoMMDQ5NzUxNzE2Nzc0IgyMzeNv%2BCDGdpp%2FZp0qyQMcsZMBThdIJp1CRKp%2BvDL%2FlFtsdZlhwGNe8lt%2Fi6WQZB0u5bGCL75SV4h3tOGk8v7QHEQxpnq89qaVgmfu8R1C%2Be0V3Mpa9Qfvj0SX4qQVHy%2Fe%2BNTKrdtBhby%2BCSRSleOBxZE1EvJgxJUpqnMczYgNbGQRygYauH%2Fj9NAAnjP4mRtLXhicPRHoTb915IozZ7DTx9qBGs0doHnW9n55esIRfv3WF2JdF7d8RZRgEklnAsjSMrn%2BjY4EcZ652xoAhiegpG4EOeIKocM1oduvxpxKhGCI82yN7wfGSX%2ByeheCY%2FAGDnDyRtstP5DWjZ1bfUSlr0T5QwN%2BhznRhi7tvfDnjbTHk53Q9Xz3f2GHGZBmvbJytRZYxzimUUzR0bFcw4U3GWmTfez2hKksmW%2Bk5lzXP3Ly7MVJE82X%2F7s5RcBCKqSwCHyrSDuurYHTTnFI%2BV2zD%2FPLLVJ6HgX8wyReq1%2BFKT3Su%2FRaDB5n%2BZtvdIsj8vvhBttUgzi6mh8OMFmIdVGWa7S%2FWJtVAXhteCn4HijI8WXiq2KhSM%2FyISCUhzxmk9TswTuDJ0v0lZ9vA1u%2FVtaw3n10GALQoJqQXVCzLDGLr8CWvIcp7snLMNvzrvYFOu4B1AkN3ikf5RkxKbUfJTcieUXx7oWm7394wK4najXQAo4thCIC7k%2Bbttj1TzKpvRHqSO1wdp1zIKrmyzaM%2F11gTo%2B9Bh%2Fcr6TnbUn7VYn1RONpyFXQvn5j3KV8fcZqRWaFHnktJJ8UJbyeTuozE4oA4LvCAHYvXrVZ7qYkU6IiBgqUG3g6Nhamsh7uwLmMBWUqXDmqZj4%2Bbu4S6YyPTXXxMygMULn6RwbL7gdBoWuRy%2BLQlK2LoZh857WwWE37%2FWsbcp5yAPZAVCgm%2B5EbNo54gi5GPc4JTnYGxzPQUp3yvkUyxfi%2BFlc%2BjzOmUsFgfw%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20200525T144528Z&X-Amz-SignedHeaders=host&X-Amz-Expires=21600&X-Amz-Credential=ASIAQXFLO6OTM6HDSOPN%2F20200525%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Signature=98df1f456d563fdd326e555a98d799d8fab3c248bcfa (I've deleted bits of the url string, but that's essentially what the URL is). Then I pull the dataFileResponse and this is the results: {"type":"http.ClientResponse","code":200,"headers":{"Accept-Ranges":"bytes","Server":"AmazonS3","ETag":"\"360dd68f115f9a46116bbc0ec36c5960-1\"","x-amz-request-id":"764050654A3E7206","Last-Modified":"Mon, 25 May 2020 14:45:27 GMT","x-amz-id-2":"C59zjQD/No/IdpfRtzMrj7cdxZnv43PuQTiSUjsIcVITa0GTcmfVRC3cfi9kootbexEwonb/2w8=","x-amz-server-side-encryption":"AES256","Content-Length":"7489","Date":"Mon, 25 May 2020 14:45:34 GMT","Content-Type":"application/octet-stream","Via":"1.1 mono004"},"body":"eyJlbWFpbCI6Inpjb25uZWN0LmFwaS4yMDIyNUB6dW9yYS5jb20iLCJmaXJzdG5hbWmVjdC5hcGkiLCJpZCI6IjJjOTJjMDk0NWQ1OTVjMmMwMTVkNjc2YjMyYTgyYTgyIiwibGFzdG5hbWUiOiJ1c2VyIiwidXNlcm5hbWUiOiJ6Y29ubmVjdC5hcGkuMjAyMjVAenVvcmEuY29tIn0KeyJlbWFpbCI6ImRuZWFsQGJsYWNrYmVycnkuY29tIiwiZmlyc3RuYW1lIjoic2FuZGJveCB0ZXN0IiwiaWQiOiIyYzkyYzBmODVkNTk2NGRhMDE1ZDY3NmIyNmI1NDc2ZCIsImxhc3RuYW1lIjoidXNlciIsInVzZXJuYW1lIjoiZGRvaW1vQGN5bGFuY2UuY29tIn0KeyJlbWFpbCI6ImFyQGN5bGFuY2UuY29tIiwiZmlyc3RuYW1lIjoiQWNjb3VudHMiLCJpZCI6IjJjOTJjMGY4NWQ1OTY0ZGEwMTVkNjc2YmNlMTc0OTY2IiwibGFzdG5hbWUiOiJSZWNlaXZhYmxlIiwidXNlcm5hbWUiOiJhckBjeWxhbmNlLmNvbSJ9CnsiZW1haWwiOiJqZWZmcmV5LnRhbkB6dW9yYS5jb20iLCJmaXJzdG5hbWUiOiJKZWZmIiwiaWQiOiIyYzkyYzBmODVlNWU3ZDRmMDE1ZTYzZDU4ZWZiNjhjYiIsImxhc3RuYW1lIjoiVGFuIiwidXNlcm5hbWUiOiJqZWZmcmV5LnRhbi5jeWxhbmNlQHp1b3JhLmNvbSJ9CnsiZW1haWwiOiJhbGV4LnN1dHR5QHp1b3JhLmNvbSIsImZpcnN0bmFtZSI6IiIsImlkIjoiMmM5MmMwZjg1ZTdmODkwNzAxNWU4Y2I4ZGVmNTBhZjAiLCJsYXN0bmFtZSI6IiIsInVzZXJuYW1lIjoiYXBpQGN5bGFuY2UuZGV2In0KeyJlbWFpbCI6ImNsaGFsbEBjeWxhbmNlLmNvbSIsImZpcnN0bmFtZSI6IkxhbmllciIsImlkIjoiMmM5MmMwZjg1ZjZiYzBiNjAxNWY3OThlMzYwMTJjYzciLCJsYXN0bmFtZSI6IkhhbGwiLCJ1c2VybmFtZSI6ImNsaGFsbEBjeWxhbmNlLmRldiJ9CnsiZW1haWwiOiJ0cnlhbkBjeWxhbmNlLmNvbSIsImZpcnN0bmFtZSI6IlRyYXZpcyIsImlkIjoiMmM5MmMwZjg1ZjZiYzBiODAxNWY3OThjZTYyYjcwOWEiLCJsYXN0bmFtZSI6IiIsInVzZXJuYW1lIjoidHJ5YW5AY3lsYW5jZS5kZXYifQp7ImVtYWlsIjoibnNwcmVpdHplckBjeWxhbmNlLmNvbSIsImZpcnN0bmFtZSI6Ik5pY2siLCJpZCI6IjJjOTJjMGY4NWY2YmMxN2EwMTVmNzk4ZDFmZWM3YWQyIiwibGFzdG5hbWUiOiIiLCJ1c2VybmFtZSI6Im5zcHJlaXR6ZXJAY3lsYW5jZS5kZXYifQp7ImVtYWlsIjoiYWxleC5zdXR0eStjeWxhbmNlbmV0c3VpdGVAenVvcmEuY29tIiwiZmlyc3RuYW1lIjoiIiwiaWQiOiIyYzkyYzBmODVmOWY3ZmU0MDE1ZmExZmEwMGRkMGM5YiIsImxhc3RuYW1lIjoiIiwidXNlcm5hbWUiOiJhbGV4LnN1dHR5K2N5bGFuY2VuZXRzdWl0ZUB6dW9yYS5jb20ifQp7ImVtYWlsIjoiYWxleC5zdXR0eStjeWxhbmNlc2ZkY0B6dW9yYS5jb20iLCJmaXJzdG5hbWUiOiIiLCJpZCI6IjJjOTJjMGY4NWY5ZjgwYTkwMTVmYTFmYTNhZDA2ZTQzIiwibGFzdG5hbWUiOiIiLCJ1c2VybmFtZSI6ImFsZXguc3V0dHkrY3lsYW5jZXNmZGNAenVvcmEuY29tIn0KeyJlbWFpbCI6ImRuZWFsQGN5bGFuY2UuY29tIiwiZmlyc3RuYW1lIjoiIiwiaWQiOiIyYzkyYzBmODVmYTVmY2E4MDE1ZmI2OWJjMDAwNmVkYiIsImxhc3RuYW1lIjoiIiwidXNlcm5hbWUiOiJhbGV4LnN1dHR5K2N5bGFuY2V6c3VpdGVAenVvcmEuY29tIn0KeyJlbWFpbCI6ImdwZXJlemRlZGlhekBjeWxhbmNlLmNvbSIsImZpcnN0bmFtZSI6IkdhYmJ5IiwiaWQiOiIyYzkyYzBmODYwNzhjNGQ0MDE2MDdiYjQ1ZjRkNTk0MCIsImxhc3RuYW1lIjoiUGVyZXogZGUgRGlheiIsInVzZXJuYW1lIjoiZ3BlcmV6ZGVkaWF6QGN5bGFuY2UuY29tIn0KeyJlbWFpbCI6Im1icmlkZ2VzQGN5bGFuY2UuY29tIiwiZmlyc3RuYW1lIjoiTWljaGFlbCIsImlkIjoiMmM5MmMwZjg2MGMwZmM2MDAxNjBkZDZhMGNlOTM1MjEiLCJsYXN0bmFtZSI6IkJyaWRnZXMiLCJ1c2VybmFtZSI6Im1icmlkZ2VzQGN5bGFuY2UuZGV2In0KeyJlbWFpbCI6ImRuZWFsQGN5bGFuY2UuY29tIiwiZmlyc3RuYW1lIjoiQm9vbWkiLCJpZCI6IjJjOTJjMGY4NjE3ODllZGEwMTYxOWIxZmNlMmE2NDVmIiwibGFzdG5hbWUiOiJadW9yYSIsInVzZXJuYW1lIjoiYm9vbWl6dW9yYUBjeWxhbmNlLmNvbSJ9CnsiZW1haWwiOiJiYmF0dHllQHp1b3JhLmNvbSIsImZpcnN0bmFtZSI6IkJyaWFuIiwiaWQiOiIyYzkyYzBmODYzMWFmNjljMDE2MzFjYWUxMzQ3NmU3OSIsImxhc3RuYW1lIjoiQmF0dHllIiwidXNlcm5hbWUiOiJiYmF0dHllLmN5bGFuY2VAenVvcmEuY29tIn0KeyJlbWFpbCI6ImJiYXR0eWVAenVvcmEuY29tIiwiZmlyc3RuYW1lIjoiIiwiaWQiOiIyYzkyYzBmODY1NDE5YTI4MDE2NTVkZjJlZGY1NjkwOCIsImxhc3RuYW1lIjoiIiwidXNlcm5hbWUiOiJiYmF0dHllK2N5bGFuY2VBUElAenVvcmEuY29tIn0KeyJlbWFpbCI6InJzYXdobmV5QGN5bGFuY2UuY29tIiwiZmlyc3RuYW1lIjoiUmFtaXRhIiwiaWQiOiIyYzkyYzBmODY1NjVmNDAxMDE2NTY4YWY2YzYxNmQ4MCIsImxhc3RuYW1lIjoiU2F3aG5leSIsInVzZXJuYW1lIjoicnNhd2huZXlAY3lsYW5jZS5jb20ifQp7ImVtYWlsIjoiYWNvb2tAY3lsYW5jZS5jb20iLCJmaXJzdG5hbWUiOiJBbXkiLCJpZCI6IjJjOTJjMGY4NjgzMjAzZmQwMTY4M2E4NTU0MmUwNDkzIiwibGF When I paste the dataFileURL into Postman, it outputs the objects in plaintext, and when I paste it into Chrome, it lets me download the decrypted jsonl file without providing any credentials or keys, so I'm not sure why NetSuite would compress the results. Regards, Ivan
... View more
