Discussion Categories

Hi Community, has anybody managed to decode (extract claims) a JWT in Appian? I'm looking at the decodeJWT() function from the JWT Plugin (provided by Appian), but it confuses me that instead of the externalSystemKey, it requires url of a JWKS repository. I have no clue how to create or access one in Appian.  I have the private key (used to sign the token) and public key (that is used for token verification by validatejwtsignature) stored in Appian as Third-Party Credentials.I'm able to generate the token (createtokenwithcustomclaims) and validate the token (validatejwtsignature) but don't know how to extract the claims from token. Complete picture (to answer why I'm using JWT) - I'm trying to integrate an Appian Portal into a third-party application that handles user authentication - I need to exchange some data (third-party app -> Appian app) and decided to utilize JWTs (the data is not confidential - we need only to ensure repudiation

Are there any official, generic guide lines when it comes to retention of information stored in the database and the documentation stored in knowledge centers (when to archive, eliminate, how to handle such situation)? It's obvious we'd have to tailor it to our specific application but I wanted to start by observing any suggestions given by Appian.  Best Regards.

Hi all - We're Using Reactivate User to procedurally reactivate accounts for re-hired contractors - but we also need to reset their passwords, as they're all accounts that previously utilized SSO.  In the past, the old accounts would have been left by the wayside and we would have just created them new ones (thus adding to the clutter-pile of disused accounts), but now we're able to change their username, which is a strong positive in general. The problem: Our customer / stakeholders are STRONGLY against forcing users to undergo the multiple clicks necessary to do a manual "forgot password" request on the sign-in page, and to be fair, nothing was "forgotten" in this case.  The days of having the "change password" smart service via plug-in are sadly long-gone, but we don't even have a way to procedurally kick off an automated password reset for a particular user.  Why? Edit: this issue is now satisfied thanks to the newer plug

Hello, We are trying to set up an integration with OneSpan Sign. When i set up Web API Authentication > Appian OAuth 2.0 clients> The Client Secret is auto-generated and is 356 characters. the Client Secret in OneSpan Sign has a limitation of 256 characters. How do we address this?

I would like to know the different ways to start a process in Case Management Studio. For example, If I would like to create cases from an excel upload with different records, would it be possible to do so?

Hi , Can anyone help me with this please!. Thank you for the help in advance. local!pdf , ri!upload: recordType!ABC(), . .... ..... shadeAlternateRows: true, addRowLink:a!dynamicLink( label: "Add", saveInto: { a!save(local!pdf, append(local!pdf, ri!upload) ) } ) I am trying to add a new row , but maybe i am using ri!upload as value  i am unable to get the desired output , the interface iis showing the same uploaded images  every time i click on add new image link. 

Can we leverage Appian as the backend for our external application developed using Blazor, enabling access to all Appian resources through APIs, including the standard Appian login, password reset, and password recovery functionalities

Hi Community, I am facing an issue while uploading the excel file using the (Import Excel to Database ) smart service in one of the process , Could you please provide some inputs why this is occurring as we have already configured with correct business DB,  Error has been attached as below,   

I created a simple RecordType and defined relation with User for createdBy and modifiedBy. I added recordlist to new Site. It was working few days back. Today I am getting the following error.  Nothing has changed in last few days. The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = HE53D] at function a!recordList: An error occurred while retrieving the data for "User". Details: Record type is marked as synced, but its data has not yet been synced or its existing synced data has been invalidated. Contact your system administrator. (APNX-1-4198-000). Synced the recordtype few times through manual or data edits through data preview screen. Please help me with why this is happening today? 

Hi All, Can you please help me how to get the intersection of  Lists of array (number array). So I have a list of  number array which I construct in the interface. I need to only pick the common element  present in all the number array . I tried with loop and reduce function but not getting the actual result . It has been achieved by taking an array element and loop over other other array and check if present in all array then keep it or remove it which I feel is very dirty way of doing .  Any suggestion would be appreciated. Thanks  Manish

two different users with the same interface and with the same input values ...the output is showing different. what could be the reasons for this ? please help logic built- input type used  is date field - user will be able to select date and from that selected date onwards it will exclude public holidays and weekends and will return the date of  first 20 business days.  for most of the users the output is as expected BUT for some users it is showing wrong output.

I'm trying to connect to a system called QuickBooks that requires oauth 2.0 in order to access information from it. I know that appian allows "oauth 2.0: client credential grant", in order to connect just with one global account for all the user to retrieve  the information. But "oauth 2.0: client credential grant" is not available in QuickBooks online at the current moment, I can only access through the "oauth 2.0: authorization code grant". The site lets me get tokens that I could use for a period of time  and I would like to see if there is a way to pass those tokens The way that QuickBooks works is:   1:the  site  can give me an access token (valid for 60 minutes) and a  refresh token (valid for 100 days). 2 the refresh token needs to send a request in order to obtain the new access token.  Because of this  I'm trying to figure out  a  way to pass this tokens throu

Hi,I've two interfaces, On selecting one row (Read only grid) then dependent interface(Read only grid) is displaying data based on the selection of rows.The issue is when I'm selecting the grid rows one by one the total count is 27. but when I select all rows quickly then the dependent interface count is reduced to 16. here is the code snippet of dependent interface. a!gridField( data: local!calculatedMetricList, initialSorts: { a!sortInfo(field: "adherence", ascending: true) }, secondarySorts: { a!sortInfo( field: "employeeFullName", ascending: true ) }, pageSize: 20, borderStyle: "LIGHT", spacing: "DENSE", selectable: true, disableRowSelectionWhen: false, selectionValue: ri!selection, selectionStyle: "ROW_HIGHLIGHT", selectionSaveInto: { ri!selection, a!save(ri!selectedSupervisorRow, save!value), a!save( ri!selectedSupervisorHierarchy, if( length(fv!selectedRows) > 0, append(

List of task is represented from which I can deactivate particular required task  Before deactivating task, I need to check if that task is present as precedent task for any other task or that itself should not have any precedent taskcurrently after clicking on deactivate icon I am getting validation msg but its for all task, but i want it for only particular task that has been used as precedent taskI need to give show When condition to validation msg for that I need task name, but due to submit link used for deactivate icon all values saved are getting refreshedis it possible to retain that values and used to show validation msg

Can someone explain why datetext() is returning 2022-11-30 given the input of the date 12/1/2022. I came across this thread which states datetext() is no longer supported however it appears within the latest (24.4) All Functions list within Appian. community.appian.com/.../issue-with-using-datetext-function-in-appian-portals

I am getting some entries in Health Check report for USRX-0041: "# of slow process tasks". There is no information link about this specific issue to https://docs.appian.com/suite/help/24.4/understanding-the-health-check-report.html I could see that  all our HIGH risk entries are process tasks with interfaces. Does anyone know how to properly solve slow process tasks? It's related to the average time spent loading/rendering the interfaces? I can see that some of those interfaces are not present on the "# of slow interfaces" item.

Hi Expert, Can we use a POST integration API which actually queries data from a third party system to configure as a Sync Record Data Source, if yes  then how ?I have created an expression to get the data using the integration object which is working fine in the Expression rule while throwing error on using the same in Record Type. Thanks, Gaurav Singh

Hello Community, Following situation: handover didn't go smoothly, so the password for the main Appian Oracle user which holds all tables was lost. The password was changed, and somehow the Data Source for the old configuration was gone in the Admin panel. Not sure how that happened, but I added it on all environments with the correct connection strings again. However, the Data Stores had to be configured anew. This luckily was no problem on Prod, but I am now facing an issue on Dev with a few distinct ones. When I select the Data Source and try to verify, I get this message: "An error occurred while attempting to verify the data store: Type definitions could not be found in the Appian data source for the following type ids: 5504 (APNX-1-4047-008)" So I tried checking the CDTs that are connected to it, and for each one I try I get this error: "HTTP Code: 500 APNX-1-4198-000 Error Evaluating UI Expression Expression evaluation error [evaluation ID = HCBTYGS5

Hello,  How can I download a document that is stored in Appian from an external system?Currently, I am document(documentId, "url") to get the document's URL, then storing that URL to a table. My external system is grabbing that URL and attempting to CURL the url to download the file. An HTML document requesting the user to sign in is returned, so I am assuming that I must authenticate to Appian. Is there any documentation that can be pointed out on this process? I could not find anything in the docs.  Thank you

We have 3 records in our application say record A, record B and record C. Record A is having one to many relation with record B where record B is having one to many relation with record C. Record A is having generic details, record B is having section details which can be multiple and record C is having one editable grid having multiple entries which is present in the above section. We are facing issue while displaying and saving the value into the rule input since we are not able to use [fv!index] for record variables. We are using only one rule input of record type A. How to make sure to show the values properly and save them properly?? This is just a mock UI i created for explaining the issue. Add member will add one more row in developer details grid. Add Team will repeat the whole section again.

I´m just starting in Appian and I want to create a process in which I upload an Excel with some registers and for each register the process create a task. Is it possible to do it easily?

Hi All, I am having a specific situation where I need your feedback and suggestions. There is a Record A pointing to Table A and Record A is having relationship with Record B (Table B). For some reasons I have created Record B1 pointing to same Table B and added the relationship in Record A. What could be the issue / performance issue with this type of relationship? Note: This is only one relationship I have explained in above example,  in actual we have more then 10 such relationships.

I have requirement to deactivate task with following requirements: 1. A list of Task is displayed and each task has Deactivate icon next to it 2. Clicking on Deactivate icon, check if task is used as precedent for other task 3. If that task is used as precedent task then deactivate action should not proceed and Validation msg should appear on UI 4. If task is not used as precedent task,  then task should be deactivated and update action is executed where record column isDeleted as marked as true 5. Currently for this Deactivate icon Submit link is used, which proceeds deactivation action on click    I am facing issue for showing up Validation msg in UI - with Submit Link/Button:  it executes the Deactivation action for non Precedent Task  but fails to show validation msg on UI(in Design interface validation msg is showing up) -with Dynamic Link: successfully shows the validation msg on UI if task is used as precedent task, but fails to deactivate task which is

Hi, I have a local variable local!tasks containing a list. In the confirmation message of a button I would like to concatenate a text with the local variable. Eg : Are you sure want to & local!tasks I want to display the list of tasks in next line  eg : Are you sure want to  task1 task2 task3 inside confirmation message of a button I am using char(10) but it is not working as expected. Is there any way to show like this in confirmation message of a button?

How can we create a rich text display menu as showing in the attached format having sub list too.