About riyazpasha

HI  @saranshsaini  ,   How was the Time formatted in your input. My format (screenshot attached) seems to be causing error during the import.   Jayan ... View more

Thank you. Figured it out weeks ago but I do appreciate you checking in ... View more

@cbak  If you're using python you can use this script here. It's best to obtain the chunk count and then iterate on it. That makes it dynamic rather than hardcoding it. # This script downloads a file in chunks. It will write all chunks to a newly # created local file with the same name as the file.  import  requests import  base64 import  sys import  json from  getAuthentication  import  userBA from  getGUIDs  import  wGuid, mGuid, fileID, fileName url = ( f 'https://api.anaplan.com/1/3/workspaces/ { wGuid } /models/ { mGuid } /'  +         f 'files/ { fileID } /chunks' ) getHeaders = {      'Authorization' : userBA } downloadHeaders = {      'Authorization' : userBA,      'Accept' :  'application/octet-stream' } getChunkData = requests.get(url,                              headers =getHeaders) with   open ( 'downloadChunkData.json' ,  'wb' )  as  f:     f.write(getChunkData.text.encode( 'utf-8' )) with   open ( 'downloadChunkData.json' ,  'r' )  as  f:     f2 = json.load(f) with   open ( f ' { fileName } ' ,  'wb' )  as  f:      for  i  in  f2:         chunkData = i         chunkID = i[ 'id' ]          print ( f 'Getting chunk  { chunkID } ' )         getChunk = requests.get(url +  f '/ { chunkID } ' ,                                  headers =downloadHeaders)         f.write(getChunk.content)          print ( 'Status code: '  +  str (getChunk.status_code)) ... View more

Hi Shailender,   I have helped customers in the past write scripts through a proxy. If you email support@anaplan.com they should be able to find similar cases where we have helped write a customer script through a proxy.   Though whitelisting domains should be the first option if possible.  ... View more

Hi @kauldheeraj    Yep, you are right. One more suggestion - if you export all the lineitems , use that file and then based on the cell count and type try to calculate the size.   It sounds complicated but you may give it a try.   Thanks, Yash  ... View more

Hi @timmapuramreddy  I think your private key is encrypted and requires the password to load it. While you were trying to get the private key through Openssl you might have provided password for it. So when you want to load the private key then you should provide the password. private key without encryption begin with  ------Begin PRIVATE KEY----------- ------End PRIVATE KEY------------- private key with encryption begin with ------Begin Encrypted PRIVATE KEY------- -------End Encrypted PRIVATE KEY--------   from cryptography.hazmat.primitives import serialization >>> with open ( "path/to/key.pem" , "rb" ) as key_file : ... private_key = serialization . load_pem_private_key ( ... key_file . read (), ... password = None , ... ) Also the URL that you have provided in the code should be https://auth.anaplan.com/token/authenticate   ... View more