Discussion Categories

Hello All, I have successfully configured a single sign-in solution that is working perfectly for our clients. However, we have a new requirement from our clients. They want to implement a process where a user added to a specific group on the Azure AD side should also be automatically added to a corresponding group on the Appian side. These groups will have the same name and purpose in both environments. To elaborate: - Azure Group: [ABC Accounts] - Appian Group: [ABC Accounts] The aim is to ensure that any user added to the specified group in Azure AD is seamlessly added to the corresponding group in Appian without manual intervention.  Please provide guidance on the steps required to set up this automated user synchronization and any best practices to ensure smooth ongoing operation. Thank you for your attention to this matter. Please let me know if you require any further information from my end. Best regards,Prasad

Hello, As shown in the screenshot below, I am able to get a ASP.NET_SessionId in HTTP Response instead of getting it in Result. In such a case how do I save it in a global variable and use it as a header input for another integration to fetch data from the other system API.

Hi Team, We have a requirement to upload/download the documents into the shared folder from appian. Could you please suggest. Thanks

Hello everyone,  I am getting a base64 value as a request. But I am unable to convert the base64 value into an image document. As a result record is not getting stored into the database table. Is there any way to convert the base64 string into document?

We are hiring Appian Developers for the following locations  Philadelphia, Delaware, New Jersey. Any one would like to know more about this exciting opportunity please contact me abhilash.p@KGIS.CO  Here is the brief JD: 4+ years related experience working in a technical role Primary responsibilities will involve developing, integrating, and debugging Appian objects; writing validation tests against existing baselines to ensure integrity of the code during Agile development efforts. Create integrations with other enterprise systems using REST APIs. Create Web APIs in Appian and secure them using OAuth 2.0 credentials. Strong background in relational database design and SQL Strong problem solving and design skills Strong communication and presentation skills

Actively hiring Appian Developers for the following locations  Philadelphia, Delaware, New Jersey. Any one would like to know more about this exciting opportunity please contact me abhilash.p@KGIS.CO  Here is the brief JD: 4+ years related experience working in a technical role Primary responsibilities will involve developing, integrating, and debugging Appian objects; writing validation tests against existing baselines to ensure integrity of the code during Agile development efforts. Create integrations with other enterprise systems using REST APIs. Create Web APIs in Appian and secure them using OAuth 2.0 credentials. Strong background in relational database design and SQL Strong problem solving and design skills Strong communication and presentation skills

Hello Community,Can someone help what is going wrong here, I am trying this in Appian community edition ? Receiving this error Expression evaluation error at function 'groupprofilerecordtypesource': The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB failure trying to convert typed value TypedValue[it=1474,v={TypedValue[it=1478,v={{{id,id,1}}}],TypedValue[it=1358,v={AND,{}}],{1,1,<null>}}] to java class com.appiancorp.common.query.Query.groupprofilerecordtypesource( query:a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: {}, ignoreFiltersWithEmptyValues: true() ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 1, sort: a!sortInfo(field: "name",ascending: true) ) ) )

I have two process variable that is CDT type. I need to if any of the process variable is null then related to that process variable entity data not executed. Like this:  = {    if(    a!isnotnullorempty(pv!dependencies),             null,    a!entityData(             entity: cons!DSE_COMMUNITIES,          data: pv!communityAllocation  ) ),     if(    a!isnotnullorempty(pv!dependencies),             null,           a!entityData(               entity: cons!DSE_DEPENDENCIES,               data: pv!dependencies    )  )} But it gives error: An error occurred while trying to write to the data store [Tables]. No values have been written. Details: org.hibernate.PropertyVal

I'm using Export to csv smart service but when i export the data it returns only the timestamp for the data time column.I want the date & time .here is my table on UI: here s the column in db: here is the CDT column: and here is the csv column:

Process Model is using Plugin, but throwing error "This Application uses MSGraph Plugin components and its throwing error by saying "User Does Not Have Rights to Perform this Operation" The user is not administrator of application? Is it required to be admin to run process model with plugin? User is part of "Process Model Creator " group.

Should able to Select only one radio button from the grid as shown in the below attachment. a!radioButtonField( label: "Sort On", labelPosition: "COLLAPSED", choiceLabels: { "Yes" }, choiceValues: {true()}, value: fv!item.sortOn, saveInto: {local!sort, a!save(local!sortIndex,fv!index), a!save(index(ri!input,"sortOn",local!sortIndex,{}),true())}, choiceLayout: "STACKED", validations: {} ) How to achieve this please suggest.

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( and(local!input1[fv!index] =1, local!input2[fv!index]=1), 1, 0 ) ) ) )

Hi All, We trying to connect to an external connection from another system. Though we are already connected, the tables we are looking for is not there. Upon checking, there are more than 2 schema available on their database, the schema that the tables we want is not the one showing on the recordType "choose database table" instead the other one. Additional Info, when creating a CDT and verifying it on Data Store, other schema and its table cant be map ( "no match table found"), however its verified for all tables under the schema that is appearing on recordType "choose database table" Can you advice if this support is on Appian Admin, or is it on the external side system to make the correct schema adjustment to be selected as default. Thanks

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( or(local!input1[fv!index]=1, local!input2[fv!index]=1), 1, 0 ) ) ) )

a!localVariables( local!input1: if( len(ri!input2) > len(ri!input1), concat( a!forEach( items: enumerate(len(ri!input2) - len(ri!input1)), expression: 0 ), ri!input1 ), ri!input1 ), local!input2: if( len(ri!input1) > len(ri!input2), concat( a!forEach( items: enumerate(len(ri!input1) - len(ri!input2)), expression: 0 ), ri!input2 ), ri!input2 ), concat( a!forEach( items: enumerate(len(local!input1)), expression: if( local!input1[fv!index] =local!input2[fv!index], 0, 1 ) ) ) )

Hi, Can someone help here... We have a database with a user credentials in a table. Will Appian allow us to access the site just by checking whether user credentials is there in the database table or not

How to get two search fields in the OSM map component to search the route from a start location to an end location?

Hi, Do we have any chance of removing the above highlighted mail ID and change to custom mail ID?? Thanks in Advance, Gousii.

Can I use same interface for 2 related actions . If a user is from group1 the related action as "group1 approval" and if user is from group2 then relatedaction is "group2approval".on approve of group1 ,some fields gets updated in db and upon approval of group2 some fields gets updated (like lastupdatedby ,status)  ,all fields are common in both the interfaces ,upon approving from group1 it shows status as "group1 approved" and if group2 approved then status as "group2 approved"

How to show multiple dropdown using the record type. The field in record type cannot be made multiple, only the record type can be made array. How to achieve this

Hi, I'm getting this Authentication failed when I replay the script. I made the user as an Admin account, added the CSRF token in the header but still the authentication fails. We have Okta SSO enabled for the application. I'm able to successfully pass through the Okta authentication via JMeter and the subsequent Appian request are failing with the above error code. Thank you for your input! Best, Manisha 

Hi fellow Appian practitioners, I am working on an integration with an external SAP system and have run into a potential Appian shortcoming, and would like to confirm this. I first do a get request to an external system authenticating endpoint to retrieve a token. That endpoint also returns three cookies in separate headers all with identical "Set-Cookie" name. I can view them when looking at the "HTTP Response" tab in the integration object after calling the API via "Test Request": Now, when moving over to the Result, the HttpResponse data type includes ONLY one "Set-Cookie" parameter, the last one, specifically. I do currently need all three cookies that will be passed into the next API call, but I have no way of accessing those in the HttpResponse headers in a process model. The integration works via Postman, as the cookies are automatically passed on to the subsequent API call. I have tried both CS with Basic Authentication as well as just

Hello everyone. I want to retrieve the key field in the dictionary(queried from cdt) based on the value present. I have the data set in following order. txt1    112      (Number (Decimal)) txt2    113     (Number (Decimal)) txt3    114    (Number (Decimal)) txt4    115   (Number (Decimal)) Input: 115 expected output: txt4 Please help me in getting the answer.

 Is there any way to check how each node of a process model is performing? Like how long a node is taking to complete. I know we have two(Default Process Model Optimization Metrics,Default Process Optimization Metrics) out of the box reports present in appian objects but can we use them if the process model does not have any attended nodes? or is there any way around to get this info?

Same tasks are getting assugned to the multiple user We are using Appian version 22.3 We have the lists of tasks available for picked-up from task pool. On a click of button GetNext, same tasks are getting assigned for the multiple users if click on the same exact time . Can someone guide us for the resolution . Thanks !!