Discussion Categories

Hi. I was trying to upload a file to Box from Appian, but the following error occurred, so I am posting this. I'm getting a Media Type error, but I'm not sure if the Request Body is written incorrectly or if I'm not connecting to Box's upload API. If anyone knows please let me know. Details below.・Integration Object ・Box account Free version for individuals   I'm guessing that the upload API cannot be executed with the free version of Box, so if you know anything about that, please let me know.   We apologize for the inconvenience, but please.

There is a requirement to trigger a scheduler at 2 PM , 10 PM and 6 AM. When scheduler will trigger, it will invoke an API by passing the last execution time to fetch set of data between last execution time to current time. Say for an example, if scheduler runs at 2 PM, then it will pass 6AM as parameter to the API so API can return data between  6AM to current time (i.e. 2PM )interval. any suggestion how to implement this following the OOB configuration? TIA

I want to implement a user-defined feature that allows specific fields to be displayed and the order to be adjusted. For example, I currently have 5 columns(column 1-5) in readonly grid, and the user can present 3 of them as needed and can adjust the order, e.g. display [column 1, column 5, column 3]. Is there any way to implement this feature? Can you give me some advice?

Has anyone gotten the following error (or similar) for the systemlogsrecordtypesource function? It's for the the Log Reader plugin. Expression evaluation error at function 'systemlogsrecordtypesource' [line 7]: 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=<null>],TypedValue[it=1154,v=<null>],{1,20,<null>}}] to java class com.appiancorp.common.query.Query. It's a simple few lines of code: systemlogsrecordtypesource( a!query( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 20) ) ) Strangely, I cannot replicate this across environments. I've confirmed the environments are on the same version of Appian, so I am unsure what to check for next.

Hi Team,  The api call is working fine in post man but it is failing in appian with below error, there is no issue at the source side as well any suggestion why appian is throwing the below error [title=Connection timed out, message=The integration execution time exceeded the configured timeout, detail=No details available] Thanks,

Hello, I am running into a "Requesting File" error on all robotic tasks. The following is the trace log for one of them (with altered client information) but the same error is occurring for all robotic tasks: [INFO] 2024-11-14 22:57:38 - - Robotic task 'updateClient' (62ced40be4b01228753f64b2), execution #3674, technology JAVA, start method API, log level TRACE, testing mode is OFF, external workflow is OFF [INFO] 2024-11-14 22:57:38 - - Robotic task will run with following parameters: [INFO] 2024-11-14 22:57:38 - - Parameter 'client', value '{"#t":5266,"#v":{"Id":4,"firstName":"C","middleName":"","lastName":"H","ssn":"4","medicaidId":"K","dateOfBirth":"1900-01-01","specialInstructions":"This client was created in APP. Please go there for full client details.","primaryLanguage":"English","ethnicity":"Unknown","gender":"female","addressLine1":"","addressLine2":"","city":"","state":"","zipcode":null,"county":"","caseManager":"","phone":"7208299615"}}' (default value 'null') [IN

We work with several clients. Some want their environments in spanish or portuguese, so most of our envs are in english for our dev team and the client's requested language.A LOT of time is spent with naming our process nodes twice: once in english when we develop, and the other in whatever other lenguage the client wants. The only reason we do this is because Appian won't let us deploy packages if even one node in a process does not have the other language node name.This really hinders the devexp for something no one will see. Is there any configuration to allow for English to be a fallback language for the process? Lets say the process has no "Spanish (MX)" names attached to the nodes. In that case, appian would automatically fall back to whatever other name the developer added to the node (in my case "English") 

Hi Community,   I am working on a POC where a third-party system interacts with my Appian Web API. The setup involves the following: 1. The third-party system is configured to call my API endpoint: https ://appianCloud.com/suite/webapi/endpoint1 for a GET operation to retrieve data using query parameters. 2. In subsequent calls, the system appends /action or /response to the same endpoint URL and performs a POST operation to modify the data for the same record.   Given this requirement, I would like to know: • Is it possible to handle this type of scenario within a single Appian Web API object? • If not, are there any known workarounds or best practices to manage such dynamic operation variations?   Looking forward to your insights. Thank you in advance!

We got the above error from production. We are not able to replicate the error in lower environment. Can anyone tell what is the root cause of this issue?

Hello! We are in need of a Slovenian locale/translation for appian and I'm wondering if any of you have any suggestions as to how would we be able to get that specific locale? Is there any way to do a custom translation and import it into appian?  Thanks, Jan

Even i gone through the documentation i cant get the exact difference plz can anyone explain in easy and simple words 

Hi, I have data in record type.  I need to implement search field to get result from record type. By using a!queryRecordType it's matching exact content. For example: If we search " How to create record type ". we will get related data like below It is possible to implement similar functionality in Appian 

Hi Team, I have two CDTs with a one-to-one relationship, which I have already designed and stored. Now, I plan to create records from the database tables. However, I encountered an issue when trying to define the relationship in the records due to the existing CDT data model design. In my current setup, the child table's primary key is used as a foreign key in the parent table. My requirement is to fetch the parent table data along with the corresponding child table data. However, with this setup, I am unable to establish the one-to-one relationship in the records as intended, and I prefer not to make any changes to the existing CDTs. Could you suggest a solution or provide guidance on how to achieve the desired relationship in Appian records without altering the CDT design? Parent :TP_EmployeeDetails TP_EmployeeAddress

Hello, all I have been requested to use the record picker component and use the selected records in the picker  to filter out the records (by identifier) in a read only grid.  The record picker returns a list of variant and I need a list of integer in order to use the filter in the grid, otherwise it will return an incompatible type error. Is there any way this can be done ? the local!selectedApprovalID does return the values I am looking for, but I am getting an error :  " Cannot apply operator [IN] to field [approvalId] when comparing to value [TypedValue[it=197,v={TypedValue[it=1,v=12],TypedValue[it=1,v=23]}]]." There was an answered question in this forum to use the index() function, but that also returns the same error. Please help,   been stuck with this issue for some hours now. Thanks.

In a template i need to give a link for Docusign to display as a link what should that be configured as in Appian side?We're getting radio button from radioGroupTabs, but we need to send link as text tab, say as tooltip parameter. But I'm not sure which parameter to use for the link  

Hello, In Admin Console, we have configured "Idle Session Timeout" as 20 minutes . The users authenticate using SAML via SSO login. However, we observed that the session is not timed out in 20 mins always. If we open multiple tabs, certain tabs are timed out whereas few are still logged in after 20 mins. Is there any reason or configuration change which needs to be done? Thanks in advance..

Hello Appian Community, I am currently using AI Skills in Appian to extract data from a document. The extracted data is being saved as text at the process model level. However, I need to convert this text into JSON format for further processing. I attempted to use the a!fromJson() function to convert the text into JSON, but I am encountering an error during the conversion. Here is what I have tried: The extracted data is stored in a process variable of type Text (e.g., pv!extractedData). I tried using a script task to convert the text to JSON using: appian Copy code a!fromJson(pv!extractedData) However, this results in an error. Error Details: My Questions: How can I ensure the text data is valid JSON and successfully convert it? Are there specific considerations or configurations required when working with AI Skills and JSON data in process models? What are the best practices for handling such scenarios? Any guidance or examples would be greatly appreciated!

I got a requirement that i have a data from db record 12800 i am using filter to filter the environment type that grid contains id, data, task,count,environment in that grid date is initall scatteered like 24-02-2024 00:00 and in another row 24-02-2024 10:00 like that i want all similar date should be in in single date and need a link near to that date filed on clicking that it should show time along with particular date and tasks enviromnets and other related data to that date field can anyone help me on that 

Hi all, I am a new to Appian, and I am required to create a workflow in Appian. According to an article, I need to install case management studio to make it easily. My understanding is correct? Without case management studio, I guess it takes a long time to create workflow... I am trying to install a sql file..., but errors occur at step3. Appian Case Management Studio Overview - Appian 23.4 Step 3: Creating database objects Copy link to clipboard To create the structure for the database tables, views, and other objects that are a part of the Appian Case Management base application, you need to run a DDL script in your database. To create the database objects: In your MariaDB business database, import and run the 01.CaseManagementStudioBasev1.2.0.sql file downloaded in Step 1. May I know how to resolve the error? Hope your advice! Best regards,

Hi All,Is there an OOTB way to clear a text box in Appian, like the X within the text field?

I have the requirement of adding Event history comments for a record. As the comments needs to be encrypted, we can encrypt the data once it's written in DB. While getting the data in record I am decrypting the comments in the Record List Configuration. I am getting the decrypted comment in the record List but in the interface of Event History I am getting the encrypted text (same as DB) even after syncing the record. As in image, I want to apply the same decryption rule as "details" parameter over "comment" parameter. Let me know if we can leverage any function or is there any work around for this.

Hi team, I have requirement such that user can edit single rows and multiple rows as well and while using pm I'm able to edit single and multiple rows as well but there is another requirement such that while editing user  can only edit 2 columns name as: "Electrical Tilt" and "Comment" but while editing electrical tilt on single or multiple row user has to make sure if combination of these 3 columns: "Shared Antenna", "Transmitter", "Antenna PAFX"  are exactly same on any row then electrical tilt of those rows will automatically gets updated  I have mentioned the code of edit UI, please let me know what could be the best approach to follow a!localVariables( local!isShowtoSite, local!siteDetails: rule!SLS_QRY_getSiteSummaryDetails(siteName: ri!siteId), local!data: ri!transmitterDetails, local!updatedData: difference(local!data, ri!transmitterDetails), { a!columnsLayout( columns: { a!c

/resized-image/__size/640x480/__key/communityserver-components-multipleuploadfilemanager/99091518_2D00_115d_2D00_416d_2D00_a0fb_2D00_2f8360c6673f-289184-complete/pastedimage1732717760969v8.png Here i queried some detail ,it is in Ac in input tab but not give Save into , in the output tab(img 2) im updating the Ac value and storing in the Target in this case it is working fine but in the input tab if i give the Save Into the value is not updating in the output tabboth Save into and Target given only the Save into come out of that Script task or what

am trying to parse txt file of 7MB using readTextFromFile() but am getting Memory Circuit Breaker error did anyone else faced this issue and can anyone please suggest the alternative to parse the txt file which has large data Thanks in advance  

Hi, I am facing issue record type syncing system failure, after updating record in process. The primary key i am using is BIGINT type.