About riyazpasha

Hi @sophiedyason ,   Create two line items which are I guess input and in the final value line item write the below formula.  Base - Base Input - (OFFSET(Base, 1, 0) - OFFSET(Base Input, 1, 0)) Thanks, Riyaz ... View more

Hi @AnnaM ,   I would like to know if this works for the below scenario.   Test Model - Worksapce 1 Prod Model - Workspace 2 If there is a process which pulls the data from the test model into Prod model( As both the models are in the different workspace will this work?)    Thanks, Riyaz Pasha ... View more

Hi @Akshay07 ,   Can I look into your scripts.     ... View more

Hi @Akshay07 ,   My issue is some what similar. I'm trying to scrap the model size across the workspace and it use to work but suddenly I'm getting the internal error 500. There are lot of reason for internal 500 error below I have listed it.  Internal 500 error reasons: Browser Cache. Incorrect database login credentials. Corrupted database. Corrupted files  Issues with your database server. Corrupted .htaccess file and PHP memory limit. Issues with third-party plugins and themes. PHP timing out or fatal PHP errors with third-party plugins. Wrong file and folder permissions. Exhausted PHP memory limit on your server Corrupted or broken .htaccess file. Errors in CGI and Perl script. In your case looks like the file is getting uploaded to the Anaplan server but when you are running the action it throws 500 error. Could you please let me know what is the status code for file upload and actions status code? I have raised the ticket with Support team and they are trying to schedule a call to understand the issue. If I hear anything from them I keep you posted.   Thanks ... View more

Hi @Santosh ,   If you are looking for the File ID to automate or you have any process in which you are loading a file then below URL will help you to retrieve the file id's.   https://us1a.app.anaplan.com/2/0/workspaces/{WorkspaceID}/models/{ModelID}/files   just replace workspace id and Model ID     ... View more

Hi @Deepu,   You are right the error is because of the period mapping. Whenever you are running the process through the scripts you have to map the time or the period other wise the dimension does not matches and the script fails.    The files will get uploaded but the actions or the process will not run de to the mapping. I don't know how you will do the mapping in the Java code but in python - {'localeName': 'en_US', 'mappingParameters': [{'entityType': 'D4_Day.S ADI', 'entityName': '2021_05_04'}]} you need to map. entity type is the date subset and entity name is the today's data because Iam uploading for today.   Thanks, Riyaz Pasha     ... View more

Hi @fabien.junod ,   Thanks for the reply. But what Iam trying to look is if I filter for non blank then the key should in a sequence manner. In the screenshot that I see 1,4,8,13 is a key(List) I want this to be in a sequence even if I filter for non blank. Thanks ... View more

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 @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