Discussion Categories

Dear Anyone, I am currently trying to execute Box API that uses JWT, But the following issue occurred when executing the Box API to obtain an access token. I get an error stating that the JWT is an invalid value, but when I check with jwt.io I can see that it is a valid value. If someone else has sent a support request asking about the same issue and it has been resolved, or alternative solutions you may suggest would be highly appreciated. [Error details]　*This is written in the body of the HTTP response. body: "{"error":"invalid_grant","error_description":"Signature verification failed"}" ・Confirmed JWT in jwt.io Thank you very much in advance for your assistance.

I have update and delete options in my related actions tab , but i want to remove the related actions tab and add the update and delete options in the summary view (Job Details) tab itself. Can anyone guide me how its done.

Dear anyone, I am currently trying to execute Box API that uses JWT, I saw an article that said that you need to set "Third-Party Credentials" when executing the Box API. However, the connection is not working properly, so if you know which field to set in the Credentials, please let me know.   Thank you very much in advance for your assistance. Best regards,

How to click on the above Menu Layout Button? using the Appian Selenium 

Is it possible to generate a unique URL to open a process in Appian? I would like to be able to start an Appian process instance using an API from another system, and open that process from a screen like "Appian process list" on the other system.A process has multiple User Input Tasks and also enters sub-processes, but I would like to be able to open the process from the "Appian Process List" no matter what state it is in.Is it possible to generate and return a unique URL for opening a process, regardless of the task, when a process instance is launched? How should I implement this?I've recently started learning Appian.Please forgive me for asking a beginner's question. Thanks in Advance.

Hi all... i have a database-table (postgresql) with 3 columns: id (integer), year (integer) and cost_pre_hour (numeric(10,2)). I would like to use this table as a source for a dropdown.As choicelabels I want a contaminated string in the format: ‘Price for year ’ + [year] + ‘ (’ + [cost_per_hour] + ‘)’[cost_per_hour] preferably formatted with 2 decimal places. I just can't get it to work. what i tried:in the record-type another calculated field:a!customFieldConcat( { "Price for  ",recordType!<recordType>.fields.year," (",?????????" euro/hour)"})for ????????? i set:text(recordType!<recordType>.fields.cost_per_hour,"#.##0,00")orcast(typeof(1.0),recordType!<recordType>.fields.cost_per_hour)or other internal-cast-functions or/and combinations.I got the error Could not cast from Record Field to .... CastInvalid or something like thatWhen i try:tostring(recordType!<recordType>.fie

Hi everyone, I'm trying to load json to db using this Appian smart serivces. My sample json data i have given below. It has multiple dynamics parameter for example user have multiple types of phone number. if it flattens json file then its working without any issue but sub paramters are not working as expected. Added more details below Main Issue while accessing the json sub parameters which is dynamic In smart service Load JSON to a database, "JSON key/Column Name mapping" Field for json fields key i have tried like this Phone.number as well as Phone[].number but while executing Process model considered as "FirstName", "Phone" as column instead of each table column fields like FirstName, PhoneType PhoneNumber. I cant able to navigate inside of sub paramters while mapping json key to table columns name Plugin name: JSON Tools Smart service name: Load JSON to a database my sample appian rule { "FirstName": "First_

I'm using a Google Sheets connected system in Appian with OAuth 2.0 authentication. The integration works initially, but I'm encountering an issue where the connection requires reauthorization almost every hour. Has anyone faced a similar problem with token expiration or session persistence? Is there a recommended way to maintain or refresh the token without requiring manual reauthorization so frequently? Appreciate any suggestions or best practices to resolve this.

I am getting this error on html to pdf converter node - java.lang.Exception: java.lang.IllegalArgumentException: null incompatible with Global antialiasing enable key Following is the html body retrieved from email Best regards,Isac Hi Eunice/Team, All set: Hi team Pls set up both tranches Thanks, Eunice Trader Additional Comments Term Sheet;<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="">schemas.microsoft.com/.../omml" xmlns="">www.w3.org/.../REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!--/* Font Definitions */@font-face {font-family:"Cambria Math"; pa

Hi Appian Community, Iam new to appian and iam still struggling at a lot of things due to my limited approach. I have recently started working on a POC which is a little bit complicated due to which iam facing a lot of blockers. It would be great if anyone is willing to guide me a little bit on how to resolve my blockers and help me complete my POC. You can just help me in your free time or how little you can. Thankyou.

Hello everyone, I believe I created a real issue by deleting documents I should have left alone. My goal was to make environment B identical to environment A.  There were existing files in environment B so my approach was to delete everything I could and then import everything from environment A.  To clear away everything in environment B I hard deleted all application files by going into the application in designer, check the box next to the file name, delete, and confirm delete.  Once all files were deleted I would then delete the application itself.  Once all applications and their corresponding files were deleted I then went after files that lived outside of the applications.  I'm fairly certain this is where I created my problem.  I deleted documents that I now believe were being used for the appian user profile pictures.  The documents I deleted had the format of <username>_180, <username>_90, <usernam

I have to open a web page as RPA Task and scroll down to click on an icon to extend the additional info. Upto scroll down to that particular section, it is working fine. But I am not able to click on the add icon to extend. Can someone guide me with the configuration.

Hi All, i want to know , how to configure the below logic BY default all the option should be selected. and also in dropdown i can have the option to deselect all /select all along with all the options. Please help me how i can go about this

Hello, We are running a query on Synced Record data using a!queryRecordType where we need to filter based on a list of Text. This is the query filter we are using: a!queryFilter( field: 'recordType!recordName.fields.email', operator: "in", value: ri!email ) The record field is type Text and contains users' emails, which vary in how they are capitalized. The rule input ri!email is a list of Text String. When we pass in only a few items to that rule input we are able to return the expected results and we do see the records being returned with the email field matched in a case-insensitive manner. However, in our implementation we need to search on a large number of emails where the capitalization is not consistent across data sources. When we pass in 173 items to the ri!email rule input, we do not see the results being returned as expected with the email field matched in a case-insensitive manner. Then, if we update that 173-item list to make t

Hi, I need to create JWT token, for this installed JWT Tools Plugin, createtoken() function is pasking for externalSystemKey as param, I don't know how and where to configure it, and if it dependent on other 3rd party integration, what to configure there and how it will handshake with apian to test? Kindly guide us on this. Thanks,

I want to have a custom record field, get data from related record field with out any aggregation it is a text field(like  we have group_concat and group by in SQL). I want to have this field as I want to apply sorting in read only grid on this column

Hello, I am trying to capture the attachments sent by email when starting a process by email is configured. I have tried to store in a variable (multiple) of type document the following data but the variable remains null: - fn!property(msg!properties,"attachment",null()) - fn!property(msg!properties,"Attachments",null()) And I also tried just msg!properties.Attachments but I get this error by email:

In a queryentity function, in an interface, I'm getting an error like "Unexpected error executing query (type: [CPVAccountsStatementTrackerDT8331], query:[queryentity expression], order by: [[Sort[FinancialInstitutionOther asc]]], filters:[(firmId = TypedValue[it=1,v=-1)])". How should I resolve this error. In one of filters, we are filtering based on -1 but this is working in some environment while failing at  some.

I created and RPA to upload a document(CSV File) from a Virtual Machine to Appian.  Everything works fine when I run the RPA manually, ie select execute from the robotic process.  However when  the RPA runs as part of my process model,  I get the following error. [ERROR] 2022-11-14 17:55:06 - - Error code APNX-1-4530-023 with message "The document cannot be uploaded because the storage limit exceeded, you do not have privilege or the document name is not unique." found for resource /api/v1/uploadDoc[WARN] 2022-11-14 17:55:06 - - Method manageException invoked I'm sure it must be some security setting in my Process model, but I can't figure it out.  Any ideas?

Hi, I have a RPA that takes files from my local machine and upload them into an Appian folder with the Upload Document module provided in Appian Services.. When I run the RPA within the Appian RPA console it works perfectly fine. I want to trigger this RPA from an Appian Process Model that uses the Robotic Process Smart Service but when I do so the RPA start fine but then I have an error that I can't solve so far... (looks like it's about the Target Folder).Error code APNX-1-4530-021 with message "docFolderUuid query paramter is not found." found for resource /api/v1/uploadDoc Can anyone help me? Thanks, Jeremy.

Hello Everyone, What is Appian Composer where can we  find that?If there documentation please do share 

Hi everyone, I’m working on a task where the expected output involves a grid that allows multiple selections. The user can select three checkboxes and then click a button. Upon clicking, a small popup should appear asking for a meeting name corresponding to the selected three IDs. I tried implementing this using a related action, but it only works for single row selection. It doesn’t support multiple row selection. I also tried using a startProcess link, but it opens a large popup. Since we’re only filling in a single text field (the meeting name), it doesn’t look good occupying the entire screen. Is there any way to achieve this more effectively? Thanks in advance!

The requirement is that Process should start on the Inbound email should receive by the process. And We need to show the Inbound Email uploaded into the task automatically, so i have used the "Create EML File From OOBT Poller" plugin which was giving the expected result but the formatting in the Body content is giving in a single line. Please suggest a way to align the email body content Process Model The output file from the pulgin 

I have a scenario to create an excel file with 3 sheets. I have used the export data store entity to excel smart service in the model back-to-back (3 times). I gave the folder to the first node, configure the output document of first node and provided the document to update field in second and third nodes respectively in order to update the same sheet. The process executes and returns the excel document that i expected. But in the history, after the execution of first node, i have one document id generated and after the execution of last excel node, another new document id is generated. At the end of the process, i write the documentId in a table. In the mentioned folder i can see only one document which is the first one. Please let me know what should i need to do? Thanks In Advance,Vishnuvarthan.

Old requirement: User used to enter multiple email addresses separated with a comma and that combined value was sent from Appian to API for sending emails. Here the highlighted rule input was saved as Text type in Interface. Now the requirement from API end has been changed and they have updated the Email addresses variable to list of items. In order to handle this I have updated the Rule input to store multiple values I tried to use a!foreach() in the saveinto parameter of  a!textField() but Interface is not recognizing the multiple values as list of items. Can i please get some suggestions on how to handle this?