About riyazpasha

HI @roblund,   I think the line item is present in the INV02 Country Summary as Safety Stock flag count - Formula 'INV01 Inventory Ordering'.Safety Stock exception count[SUM: 'SYS08 SKU Details'.Country Made In].   The formula is exact. Check with the format. Also if you can attaché the error that you are encountering that would help us to find the exact issue. Also please check the line items names that should match in the formula(Capital letters, small letters or spelling check)  ... View more

HI @cbak ,   I don't think that you can change the chunk count because its auto created when an export is defined. You can refer to the below questions that has been discussed.   Exporting the Files by API using Python  Also my understanding is when Chunk Count 0 - signifies that you are downloading the file before you trigger the export action. ... View more

Hi @adarshbarodia,   You can pull the volumes data from DATA02 module. Add a line item and write the formula : 'DATA02 SKU Volumes'.Volumes and you will get the data from the DATA02 module.     ... View more

Hi @JaredDolich , Thanks for Quick reply. I guess the profile function would not work in my scenario because profile function needs a value but in my scenario its percentage that has to be redistributed to other properties equally. If you could give an example that would help me a lot.    Thanks  ... View more

HI @saranshsaini ,   Check the mapping of the line items while importing and also share the screenshot of the mapping while you are uploading the file. ... View more

Hi @Shailendr , Yes you can define the proxies in the script and use it when you are using the get request for api.anaplan.com To get the proxies use the below code. import urllib.request proxies = urllib.request.getproxies() print(proxies)   define a new function as shown below : def get_proxies(): return { 'http': 'http://domainame/username:password@proxyIP:port', 'https': domainame/username:password@proxyIP:port', 'ftp': 'ftp://domainame/username:password@proxyIP:port' } Note : If the password contains special characters then you have to percent encode it. Now while hitting a get request or Put request or post request use the below code to call the proxies. url = 'https://auth.anaplan.com/token/authenticate' request = request.post(url,headers=headers,data= data,proxies=get_proxies())   Note : The above code is not intended please make sure you intendent it properly. ... View more

Hi @kauldheeraj  Try this end point which will list all the models in that particular workspace. https://api.anaplan.com/2/0/workspaces/workspaceID/models 1. You would require workspace ID, Model ID and Model name from the models end points. 2. To scrap the data first you have to identify the Class name for the workspace by going to the any of the model and click on your account and then click manage models. The window listing all the models in that workspace will appear, then you can see at the top left "workspace size". Then try to find out the class name or class ID(right click and click on inspect) which is listing all the models. 3. Then use the selenium library to find the ID by element and pass the class ID which you found for the models and get the text which will give the model size. 4. Now you need a function to convert the size in one standard format. The model size can be in KB, MB or GB so you need to convert the size in to one format and write all the data to an excel file   Note : You need to loop through each workspace first to get the models. ... View more

Hi @kauldheeraj  You can get the size of the models through the API but not sure about the size of modules. However you need to write the scripts to scrap the data looping through the each workspace and Models. 1. Write the function to get the all the Workspace details (will be in JSON format)  2. Another function to get the Model details. - Will be in JSON format For above two functions you need to use the request library to hit the get request which would require basic authentication. 3. Create a function to scrap the data which would take the workspace ID and model ID as input. In this function you need the selenium library to initiative the login to the Anaplan using the webdriver.Firefox() function and then hit a get request to the Anaplan end points. 4. Loop through the each workspace and model and locate the size of the model using the selenium functions and then convert the size into the required format(GB,MB etc) and save all the details to an excel file. ... 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