Hi Chi,   You are absolutely right! It was in base64. I am not sure why when NetSuite pulled the data in that it brought it in as base64, but once I converted it back to UTF 8, everything showed up as text that I could make sense.   Do you know when users will be part of the API scope?   Thank you very much for your help! Much appreciated 🙂 Warm regards, Ivan ... View more

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

Hi Chi,   Thank you very much for your quick response. I looked over the documentation and tried what you suggested. I was able to submit a data query and get the data query based on the ID that the submit generated.   In Postman, after the GET call, I can see the dataFile that contains a jsonl URL with a lot of parameters appended to it. Clicking on it opens up a new tab and hitting send will output all of my users in a plain text format.   When I run this in the system I am planning to do all of my analysis in, passing the URL in the GET command only outputs what appears to be an encrypted string... Do you know if Postman decrypts the data while it's reading it or if there's something else I need to do to get the data out in my system?   Thanks again for your assistance! Ivan ... View more