Discussion Categories

In a pipeline : as an input I have a parquet file I'd like to do row by row of the parquet file (foreach ?): make a call to a soap xml api according to result call : = if ok store the result (xml file) in a blob container. = if not ok store the result in an azure storage table. I've already done such a thing with an azure webjob would it be makable (rather simply) with azure synapse analytics ?

Hi All, One of our old application was storing date time as TEXT format. Some of the values in DB for column called 'datetime TEXT" column are  5/15/2018 2:57 PM GMT-04:00 5/15/2018 2:57 PM GMT-05:00  3/12/2018 5:25 PM EDT 2/6/2018 1:48 PM EST Recently we are trying to add new column to store this value. Just say "dateTime" column with datetime type. On doing so we will be storing in datetime format for all new request after this update. But for older request the value will be in TEXT format as mentioned above. Can anyone suggest best way to convert and populate datetime for older request into the new column which i have created. dateTime(TEXT) dateTime 5/15/2018 2:57 PM GMT-04:00 ? old 5/15/2018 2:57 PM GMT-04:00 ? old 5/15/2018 2:57 PM GMT-04:00 ? old 10/18/2017 14:02 new 10/18/2017 14:02 new 10/18/2017 14:02 new

Hello, I'm using function a!recordData to return data from one of my records and I need to apply multiple filtering on the dataset: data: a!recordData( recordType: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident', filters: { a!queryFilter( field: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident.fields.{a1a9fdf7-1d9b-48eb-a147-2a233271d74b}adGroup', operator: "=", value: local!adGroup ), a!queryFilter( field: 'recordType!{a24eedc6-9d03-4ecc-affc-9d0a19c7cc0d}QUA Incident.fields.{3729b606-5b1b-4fb8-b16b-c9e929833ece}assignedTo', operator: "", value: loggedInUser() ) } ) When I use both filters, data is not appearing at all, If I remove the second condition I can see some results that are aligned with the first filter definition. However, If I use a!queryEntity function to retrieve the same data for the same entity I get 2 results ( the expected result). a!queryLogicalExpression( operator: "AND",

Hi Team, We are using SQLBackupAndFTP tool for taking backup of database in MariaDB (Appian). We have installed the tool while setting up, getting an error stating that Database is not detected. Please find the attached snippet for reference. Please help us here to fix the issue. Thanks in advance. Best Regards, Raj

Hi, Is there a way to limit the number of concurrent sessions for users authenticating against SAML IdP, specifically Azure? We've tried configuring the limit as described in https://docs.appian.com/suite/help/20.4/Appian_Administration_Console.html#account-locking but it seems it's only applicable for Appian-based authentication. Thanks

I have an expense CDT . It has fields like base charges, fuel charges, taxes. I have a pie chart and on each slice of a pie i need to display the sum of base charges, fuel charges and taxes for a vehicle . I am unable to use secondary grouping. Kindly please help.

Hi All ,  I have values stored in database in a particular field i.e. say previousValues, like below  "{"name":"xyz","regDate":"2012-07-01","regStatus":"Completed"}"  --   (Text) Now my requirement is to fetch regStatus value from this format .  How can I achieve this

We have a n export scheduled to ran daily for billing , when Microsoft has outages and task fail we do not get any alert for the failed export job and we cannot even see event logs. How can we create alert for any failed export or job not received in the billing export container We haven't tried anything as yet , since MIcrosoft Engineers couldn't help us .

Hello Community, Does anyone knows how to read data from a docx file in the same way we can do for PDF files? I read that is possible to convert docx files to pdf and maybe accomplish this, but not sure. Please let me know if you have some ideas how to accomplish this. Thank you

I'm facing two issues:1. Warning is coming in process instance - Some referenced items could not be found. Please check the model and correct any problems.2. Action Complete banner flashes out..

Hi, can anyone help me how to generate web API for API Key authentication? And also how to generate the key and value needed for the API key

I'm trying to connect the UIpath orchestrator in Appian connected system. Eventhough my credentials are correct, its showing invalid credetial URL I tried- platform.uipath.com/[organization name]/[[Logical name]/orchestrator_ https://cloud.uipath.com/[organization name]/[[Logical name]/orchestrator_ https://platform.uipath.com/ https://cloud.uipath.com/ I got the below error for all the URL's i tried

I was trying out this plugin called "Timer Component". It basically provides us with a stopwatch functionality. We can also stop it automatically at some given time interval. I just tried to create a functionality where this plugin can be used to refresh a variable automatically in custom time intervals ( also less than 30 sec). Is it a good way to do it? a!localVariables( local!total: 50, local!bool: false, local!refreshAfter: 5, { stopWatchField( /*label: "Stopwatch Timer",*/ labelPosition: "ABOVE", validations: {}, height: "AUTO", action: "START", size: null, align: null, expiredMessage: null, color: "#FFF", style: null, timerDirection: null, enableReverseTimer: null, reverseTimerColor: null, secondsValue: local!total, secondsSaveInto: { a!save( local!bool, not(local!bool) ), a!save( local!total, local!total-l

Hi, I am getting below cast invalid error for below rule. Please help in resolving this. The same code is working fine in one of our environments but not in another environment. "Expression evaluation error at function a!queryEntity_22r2: Could not cast from Boolean to Data Store Entity. Details: CastInvalidCould not cast from Boolean to Data Store Entity. Details: CastInvalid" a!queryEntity_22r2( entity: cons!RGRACSLBL_ENTITY_NEW_PROJECTS_EVENTS_VIEW, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "processId_int", operator: "not null" ), a!queryFilter( field: "isExistingCountry_bool", operator: "=", value: ri!isExistingCountry_bool ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: - 1 ) ), fetchTotalCount:true() ).data

Hi, I had a question regarding calling the webApi outside Appian. Is that possible and how can it be done?

Hi All, I came across a question where the environment should get upgraded to latest version. Should we start upgrading the higher environments first and go down to lower environment upgrade or vice-versa, and what will be the impact in both cases. Can someone help in knowing this impact?

Hi, I am trying to use a!writeRecord function in an interface button save into block. Below is my code. Id is a Primary Key and is set as AUTO_INCREMENT in the database table. When I set the id as 0, it doesn't seem to accept the identifier and hence fails. What should I do in order to write a new entry into the table using this function? PS : I am able to update the record and the corresponding row in the DB with an existing identifier.

Hi, I would like to send error details to an email DL when there is an issue with process model functionality. The below option is allowing me to create a reference to an Appian group and specify at this place. But, I would like to provide an email DL so that all the people who are the part of the email DL should receive the email with error details.

Hi, I have a big user interface form where I am using multiple controls. Now when I try to submit a form data by clicking "Submit" button it is taking few seconds to complete the submission and it between it is allowing use to click on different form elements and it is creating an issue. So, when the user clicks on the "Submit" button, I would like to show a rotate/progress bar so that user can't click on any other elements of the form. Is this possible in Appian 22.4? Can someone advise please. Thanks in advance.

I need get a document from the external cloud source and need to do data extraction using IDP process model and convert the data into the CSV file and source the file in another external cloud folder can it be done in IDP  or RPA ? if yes how to do that. 

Hi Experts, I have a requirement where I need to store 100 phone numbers in a given field, i.e Targets for now. And then to filter the data on all the columns considering if user searches with 555 then 2nd record should be returned Currently I was using a single table with structure as shown below TargetID (num) OrderID (num) Targets(varchar) 1 1 +91-9999999999+91-9999999999+91-8888888888 2 1 +91-9999999999+91-9999999999+91-8888888888+91-5555555555 Now, due to some performance issues, we need to get that targets column to be moved to a separate table and store all the phone numbers as a separate row, as shown in below tables TargetID OrderID 1 1 2 1 id TargetID Targets 1 1 +91-9999999999 2 1 +91-9999999999 3 1 +91-8888888888 4 2 +91-9999999999 5 2 +91-9999999999 6 2 +91-8888888888 7 2 +91-5555555555 Kindly suggest as how this can be implement, do we need to use nested CDT or if there is any other way possible. Thanks, Gaurav Singh

Hi, is it possible to receive multiple messages on one Receive Message Event? I need to use Receive Message Event to stop the process flow until all the fields of multiple entities are populated, so I have a Send Message Event on each asynch subprocess that sends a message to my main one that the fields have been populated. There is also an Expression Condition on Receive Message Event that checks if all entities have populated values. If it's possible to receive multiple messages, does the condition get validated each time it receives a message? Thanks!

Hello,As the title says, I'm trying to extract data from a table using Appian RPA, and then apply some transformation to that data, and save it to a variable also in the RPA.The data is being fetched correclty, and the transformation "tested independently" is also working, but when trying to combine them, it doesn't work, as no data is being written to the final variable.Can anyone help me please?Thank you in advance!

Hello,I'm trying to create an RPA that fetches data from a table from a system and then do operations on that data.I'm able to fetch the table data, and I have a section with a expression rule that does the correct parsing on that data, but I'm not able to use them in junction.I'm trying to pass the data like this (the value is not empty), but the value being passed is always empty, according to logs.Anyone can help me with what I'm doing wrong?

Hi, I have text field in an interface and I need to trim the Leading and trailing spaces for the value if there any. So I have used trim() as in below code. I tested by giving some sample text with leading and trailing spaces, trim() has removed all the trailing and leading spaces in the interface. But when I checked the CDT to see how it stored, the spaces are still there and it is carrying forward the same value to next screens also. Can anyone please help me in resolving this.    a!textField( label: "Bundled Submission Description", labelPosition: "ADJACENT", value: trim(ri!bundle.submissionDesc_txt), saveInto: ri!bundle.submissionDesc_txt, required: true, validations: rule!RGRACSLBL_FN_getTextLengthValidationMessage( input_txt: index( ri!bundle, "submissionDesc_txt", {