General

I am trying to add JSON object inside a JSON object but the generated JSON is not in the correct format. The child json is in double quotes.  How can I get rid of these double quotes? Can someone help me with a correct substitute() function command?

Hello everyone, I wanted to share a little advice with you, and hopefully, maybe Appian will also take note and resolve what an abysmal design decision is.Problem Statement:Appian has created the teardown method as a step that runs in the feature file. This is a terrible design. The reason it's a bad design is that the teardown method is what closes the browser and also kills the background Chrome/Firefox driver process. Since it's being invoked as a feature step, this means that if your test fails, the teardown step/method will not be reached. In addition, if you end a test early, it will not be called. The implication of this is that you end up with lots of browsers you have to close manually, and even worse, every time it happens, you have a driver process running in your PC/Mac background, and the more times you do it, the more they add up, eating away at your memory until you have to reboot your PC/Mac. I will show a screenshot of the step I am referring to.  Sol

I have a grid with dynamic column names and static columns. Ex :  Here EmpSub's will varies on each instance.Need the word document format to get the dynamic columns syntax in word document. Able to get the rows data from the CreateDictinoary function but need the exact format to write in the word document. Thanks in Advance.

Hi, I need to find out if a given date is in the last week of the month.  For example 27th of March 2023 is in the last week of the March month.  How can I achieve this?  Please give me the suggestions. Thanks and Regards, Brinda Sateesh

Hello everyone,We are trying to make sure SAML users, if idle, logout after 60 minutes. But for some reason the timeout is set to 20  minutes. After going through the documentation I have seen Admin console> Appian >session time out is suppose to fix it but it doesn't seem to work in my case. Any idea where to start?

I have a scenerio.The below mentioned example rule should repat based on the local variable local!a each input. localvariablesa( local!a: {"A","B","C"}, local!b : {"X","Y","Z"}, a!forEach(items: local!b, expression : rule!getTestData(input1 : ri!employee, input2 : local!a[1])[fvIndex], rule!getTestData(input1 : ri!employee, input2 : local!a[2])[fvIndex], . . . . rule!getTestData(input1 : ri!employee, input2 : local!a[n])[fvIndex], ) )

Hi, I have a scheduled process that executes multiple SQL scripts.The final of these scripts recreates triggers dropped in the first script. Since triggers can't be created in a Stored Procedure; I am unable to use the Execute Stored Procedure smart service and, due to the scripts complexity, use the Query Database smart service. Is there another way this can be executed from the process model? Thanks

I'm trying to  extract  a  big amount of question from a  PDF file that has around 1000 pages  and the section  where we find all those questions. The program is doing it  we can run  the process an everiything is fine but suddenly  the appian server  shows the 503  error   even though we are not running the process i split the pdf  in  batches of 30 pages  every time a 30 page batch   is evalueated and the  questions are extracted we save the   questions found in this  variables and this sub process die and  go  to the main process  and do the same  thing till  we get to  have all the questions and sections   the  time for this process is about 10 minutes in doing all of this operations. how can we minimize the high load of the site ?  the Appian team told us that the aplication server was killed by their automation. After

In a pipeline : as an input I have a parquet file I'd like to do row by row of the parquet file (foreach ?): make a call to a soap xml api according to result call : = if ok store the result (xml file) in a blob container. = if not ok store the result in an azure storage table. I've already done such a thing with an azure webjob would it be makable (rather simply) with azure synapse analytics ?

We have a n export scheduled to ran daily for billing , when Microsoft has outages and task fail we do not get any alert for the failed export job and we cannot even see event logs. How can we create alert for any failed export or job not received in the billing export container We haven't tried anything as yet , since MIcrosoft Engineers couldn't help us .

Hello Community, Does anyone knows how to read data from a docx file in the same way we can do for PDF files? I read that is possible to convert docx files to pdf and maybe accomplish this, but not sure. Please let me know if you have some ideas how to accomplish this. Thank you

Hi, is it possible to receive multiple messages on one Receive Message Event? I need to use Receive Message Event to stop the process flow until all the fields of multiple entities are populated, so I have a Send Message Event on each asynch subprocess that sends a message to my main one that the fields have been populated. There is also an Expression Condition on Receive Message Event that checks if all entities have populated values. If it's possible to receive multiple messages, does the condition get validated each time it receives a message? Thanks!

How to set date-time format into : "jul 8 , 2021 9:35 AM" from using Date-time 

i have few doubts can someone clear me the doubts? i want to write the exam for L1 so which exam i have to take? here i found these, but not sure which is exam is for which level if i want to write L1 and L2 exams at a time then, which exams i have to register for and take?

First Create Function To Calculate Sum called : Calculate_Sum a!localVariables( if( ri!monthName null, sum( todecimal(index(ri!months, { ri!monthName }, 0)) ), sum( todecimal(ri!months.jan, 0), todecimal(ri!months.feb, 0), todecimal(ri!months.mar, 0), todecimal(ri!months.apr, 0), todecimal(ri!months.may, 0), todecimal(ri!months.june, 0), todecimal(ri!months.july, 0), todecimal(ri!months.aug, 0), todecimal(ri!months.sep, 0), todecimal(ri!months.oct, 0), todecimal(ri!months.nov, 0), todecimal(ri!months.dec, 0) ) ) ) Now Create Form in Grid to calculate and call the sum function: a!localVariables( local!invalidIncome: ("Please insert valid income value."), local!DuplicateIncome: ( "Duplicate value. Please check and delete if duplicated" ), local!CurrentRow: 0, local!TotalRow: 0, local!monthDetail: a!map( jan: null, feb: null, ma

Hi All, Multiplying the below values by product function and expecting to return output as 16956.0843 but it is returning the output as 16956.08.  product(16746.75 * 1.0125) Regards,Sandeep

I was making a query today in which I wanted to find entries based on a particular field and if that field happens to be null, I want all the entries that have that field null. I ended up with 2 filters, one that looks for entries when the value is not null, and one that looks for entries when the value is null. It works and all, but the thing is there's a parameter called ignoreFiltersWithEmptyValues that is usually true by default. But you can make it false and now instead of ignoring those filters with empty values, it gives an error for each filter with empty values. My question is why does this parameter even exist if all turning it off does is cause an error on null values? Wouldn't it make more sense to search for null values instead? 

Hi All, Input code: a!toJson( value: {test: { assuranceText: "Jag försäkrar att uppgifterna jag har lämnat är riktiga och bekräftar att jag har tagit del av informationen och villkoren ovan.\n\nDin ansökan grundas på automatiserad behandling av dina personuppgifter. På vår hemsida och under inställningar kan du läsa mera om hur vi behandlar dina personuppgifter och om dina rättigheter.\n\nNär du skickar in din ansökan kommer en kreditupplysning om dig att hämtas in ifrån UC" } }, removenulloremptyfields: true()) I am geeting the out put as below: in the output you can observer that one extra backword is added for the newline character

Hi, I am handling documents in Appian using "a!fileUploadField". When we upload the files/documents using this component it is allowing to upload the files/documents to a specific Folder which we have created inside Appian. I would like to check if there is a way I can upload the documents to the network folder which is mounted. Any advises please.

Hi, I am using a smart service called "Export Data Store Entity to Excel" and generating a document and storing in a pv! variable. Now, when I try to attach the same document in the "Send E-Mail" service, I am getting an error. I passed the variable to the "Attachments" like pv!reportName and tointeger(pv!reportName), but still no luck. By looking into an error message I was unable to find the root cause. Can someone advise please. ERROR: Problem:  An error occurred in executing an Activity Class. Details:  Failed to process attachments Recommended Action:  Examine the activity class to correct the error and then resume. Priority of this problem: High Priority

What all cases are covered while using validateemailaddress() ?

I have a use case to check if a group already exists. And if not, we should create the group. Is there any way to check a group exists in an environment already.

Do you have any idea on how to check if all values in array matched in appian? example arrayValue = {true,true,true} returns "All Elements are Same" else returns "Not the same"

Hello Everyone, In recent days, We are seeing this error in the tomcat-stdOut.log. In the front end, we are getting, An error encountered while processing the request. ERROR com.appiancorp.rest.shared.FallbackExceptionMapper - Internal Server Error on REST API invocation. com.appian.komodo.api.exceptions.SignalException: At least one referenced Activity Class Schema is invalid: ,304 Can you help us on solving this issue? Thanks in Advance

How to configure a key in CDT?