AI and Agentic Automation

Hi, In some ER code, I have found this kind of things : rule!APP_GreaterTo(value: _, to: 14), or :       contains(        reject(          isnull(_),          ri!names        ),        tostring(ri!name)      ),                                                  Could you explain me what does mean that "_" ? is it just to specify we do not want to pass any parameter in the function ?  (because "isnull()" is not authorized) but why "value: _"  in place of "value: null" ?

Hi All I have a requirement to query a value in nested CDT which is in 1:M relationship Is it possible ?

a!gridColumn( label: "Assignees", sortField: "c4", value:group(fv!row.c4, "groupName") ), Using this code in a gridfield. Getting the data from queryprocessanalytics to populate a grid. Field c4 contains the group number. i am trying to get the corresponding group name. Pls help.

I have a REST service that returns JSON which is converted to Dictionary by the integration.  I have CDTs I have imported from the service WSDL (so the property names exactly match the JSON names).  The problem is that array properties are left null instead of being populated. I'm trying to convert it this way.... with a single call to cast of the top-level node. /*local!rawData: rule!SH_GetLibraryIntegration(libraryName: ri!libraryName) */ local!rawData: a!fromJson( "{""GetLibraryResult"":{""Name"":""Uptown Public Library"",""HeadLibrarian"":""Kathlyn Walton"",""Books"":[{""Author"":""Fyodor Dostoevsky"",""Title"":""Crime and Punishment"",""IsCheckedOut"":false,""DueDate"":null},{""Author"":""Charles Dickens"",""Title"":""A Tale of Two Cities"",""IsCheckedOut"":true,""DueDate"":""01-10-2021""}]}}" ), fn!cast( 'type!{http://schemas.datacontract.org/2004/07/TestService}Library', local!rawData.GetLibraryResult ) However, The "books" (in my

Hi All, I am getting error in below expression  a!localVariables(           local!userName: "xyzUser",           if(                isusernametaken(local!userName),                a!isUserMemberOfGroup(local!userName, cons!PP_GROUP_CONSTANT),                0              )) Error as Expression evaluation error at function a!isUserMemberOfGroup [line 5]: [InvalidUserException] I observed this issue with deactivated user in only one environment where in lower environment its working fine with deactivate users as well. Thanks in Advance!

Hi all, I'm currently having an issue where a!exportDataStoreEntityToExcel is only working for people in the admin group for the application. Is there a way to configure a!exportDataStoreEntityToExcel to work for "All Users" within the application?

How can I write below SQL query through query entity in Appian Select * from A where A.colmn1 = max(A.colmn1)

HI  here i have used <br> tag for new line now the issue is whether the values is present in limitamout or not it's going to new line/ breaking the line  this is how the output looks like  but whenever the data is empty then it shouldn't break the line  how it can be done 

hi All ,  How to update a document type constant.  I am trying to update using a Update Constant smart service , but its not worth it .Please tell me so that I can achieve this easily.  Thanks in Advance 

Hi Community, I need to display the list of folders and files inside specific SharePoint folder. I have the access to see the folders and files in SharePoint, but the Appian Integration shows no result although the integration tests successfully. Note that, the connected system test connection success too. This is the folder path: This is the integration result:

What is the best approach to trigger workflow when ever an image is uploaded.? Can the image upload be done using an web API exposed by Appian? Can anyone kindly share any documentation or example for implementation help

What is the best approach to trigger workflow when ever an image is uploaded, Can the image upload be done using an web API exposed by Appian. 

I have doubt on POST API, Firstly I am creating an API  can I know where the document would come within Appian from external system using POST API.

i have created a web API to upload a image. the image is storing in the destination location but cannot able to store mapping in DB

I want to upload an image with the POST request and retrieve it from database. How can I do that? 1. To which datatype can we assign the document? 2. How can we convert to image into base64? 3. How can we encode and decode? 

Hello, is it possible to have a conditional sort on multiple columns in a query rule? I need to sort the data by modified date and created date columns. Modified date might be null for some rows. Below order by expression gives just what i want when i use it with the SQL query. Is there a way of creating same logic in a query rule? order by case when MODIFIED_DATE is null then CREATED_DATE else MODIFIED_DATE end DESC I tried below code but it didn't help. pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1, sort: {a!sortInfo(field: "createdDate", ascending: false), a!sortInfo(field: "modifiedDate", ascending: false)} )

hi, for ex, if i enter some date from that date till today how many days? how to count no of days 

any() 

Hi there, I am new to Google Cloud Document OCR Connected System in Appian. I have created the connected system. just want to use it in the integration. but I dont know what should be put in the two circled fields in attached pic. Do I need to go to google to create a "Google Storage"? or Appian provide these storage? if I need to create myself, anyone can provide information how to do it? and the credential use to create google storage need to match the credential used to create the connected system? regards, L  

I have a situation where I need to hold a task for a certain time period. The condition is as follow: 1) If the task is activated before 8.30 AM on a particular day, it should wait till 8.30 AM to be completed. If not , it should take the exception path post 8.30 AM. 2) If the task is activated after 8.30 AM on a particular day, it should wait till 8.30 AM of the next day to be completed. If not , it should take the exception path post 8.30 AM on next day. Can anyone please help us on the above logic?

Hi, I am validating just uploaded document size  with below code: if( rule!APN_isBlank(ri!documentId), { fullName: null(), name: null(), ext: null(), size: tointeger(null()) }, a!localVariables( local!value: a!fileUploadField(value: todocument(ri!documentId), target:cons!RMO_FOLDER_ALL_DOCUMENTS, fileNames: fv!file), local!fileDetails: tostring(local!value.contents.value.filename), local!fileName: extract(local!fileDetails, "[name=", ", extension" )[1], local!fileExt: extract(local!fileDetails, "extension=", ", size")[1], local!fileSize: tointeger(extract(local!fileDetails, "size=", "]")[1]), { fullName: local!fileName & if(rule!APN_isBlank(local!fileExt), "", "." & local!fileExt), name: local!fileName, ext: local!fileExt, size: local!fileSize } )) Issue: After clicking on submitting button, document name storing as [name=Document Name, extension=docx, size=3752844] instead of only d

"APPIAN" (TEXT TYPE)  --- Should return in "NAIPPA"

Hi, We are using webservicequery() function for calling an SOAP API which is taking more than 90 seconds to retrieve the data, Which is causing Appian to error out due to default 60 seconds socket timeout. So we increased the socket timeout to 180 seconds, After this change Appian doesn’t error out and also doesn’t show response data.  I'm not sure but I think the default auto retry at every 60 sec of Appian error handling is causing problems https://docs.appian.com/suite/help/22.1/Automatic_Error_Handling.html#external-error-handling. Does anyone know the root cause of this issue  ? Thanks in Advance

Goal: name1, name2, name3 (show and hide comas in between and names if they are selected)  Default is N/A if no names are selected What I have tried: if(isnull({pv!process.name1,pv!process.name2,pv!process.name3}), "N/A","") & if(isnull(pv!process.name1), "",", "& pv!process.name1) & if(isnull(pv!process.name2), "", ", "&pv!process.name2) & if(isnull(pv!process.name3), "", ", "&pv!process.name3))