Discussion Categories

Hi  is there any way to download document file directly from Process Model by just  initiating the process without any link 

Hi Team, When using import CSV to Database smart service, is there a way to update the data after uploading the document Eg: In my excel file, I have 3 columns id, name, updatedon id and name values will be availble in the csv file, after uploading the file and when writing to DB we need to update the updatedon value with the updatedon time.

I am getting this error while executing PM to generate PDF from docx how can i resolve this ? error : Reference is not allowed in prolog.

I am using a script task to use a expression rule. Saving the value to use further in process model. But getting the error: "There was an error in an expression in encryption at Output Expressions : Neither variable(s) nor rule(s) found: expression". I am facing the error today only, before that it was fine.

Can I skip the login step through RPA robotics process, while executing a task?

Hi, When I'm trying to upload a document by using startprocess , I'm not able to get the name using document() function. It's showing error as document doesn't exist/ has been deleted. But the document is present in target folder and docid is present..Let me know if am missing anything:

Hi,I have an webapi which accepts xml as body request, So in order to test that webapi, I'm passing below xml:<UserInformation><id>TestUser1</id><isAppianUser>true</isAppianUser><firstName>Test</firstName><lastName>User1</lastName><name>Test User 1</name><systemRole>{'Initiator','Manager'}</systemRole><market>Hong Kong</market></UserInformation>But I'm getting below error when I test: can anyone help me how to test webapi in this case.

Hi, I am trying to upgrade from 22.1 to 23.2 in my local machine. while starting the services, all engines are running in Primary mode except exec02 engine.I am getting below error in db_PX021_2023-09-07_1335.log 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Default) INFO .u "Hashing count of 10432 UUIDs into short hash for table U" 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Base) INFO .migrate " 0% Migrating from version: migrate_null_process_history_221" 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Base) INFO .migrate " 10% Updating version tag to: reset_analytics_timer_type_221" 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Base) INFO .migrate " 20% Updating version tag to: reset_analytics_timer_type_222" 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Base) INFO .migrate " 30% Updating version tag to: reset_analytics_timer_type_223" 2023-09-21 00:28:17 [PX021] {pe5566.kdb ,97481397} (Base) INFO .migrate " 40% Done: migrate_process_model_history

Hi, I have a Web API (Method GET) that sporadically fails and responds with http status 500. When I test it manually, with the same request, it works perfectly. Checking web api logs (web_api_req_resp_activity.log) I see: "body" : "500 - Internal Server Error" Checking tomcat-stdOut.log I see:[Appian AppianServerThreadPoolProvider 1680924] ERROR com.appiancorp.connectedsystems.http.execution.AppianHttpRequestExecutor - ConnectorRuntimeException [title=Connection timed out, The integration execution time exceeded the configured timeout] Checking design_errors.csv I see:All_Digital_Channels,AWS_GetPage (getpage),Web API,API Web Services,APNX-1-4198-000,Expression evaluation error [evaluation ID = a6e0f:1d079] in rule 'aws_aaabbb': Invalid index: Cannot index property 'body' of type Text into type Text,a6e0f454abd9e91cd6945ab8487579a8:1d079c3d00638e7f,aeccefc3-09ab-4951-9e47-80ff276293b2,,,,,,,, This error doesn't seem to make sense to me because w

Hi all, I have created an Appian web API that insert record on our server using Appian tables, this API is consumed by SAP to insert data.And it saves data ,but when an error occurs, how we can provide information about the specific input field where the error occured and give a customised error  message to the end user.We need help and support from the Appian team to provide a detailed and customized error message for a webapi. Hope anyone can help us on this scenario?

Hi, have a requirement to short a record field which have integer value how can i do that ?

HI Appian team, I need help from you to show custom error message in a web api, i have asked the same question 4 months ago, in that i got a suggestion that to create an expression rule and validate the api using that ,but where i can use expression rule in an API, Please find the code attached to understand webapi code and expression rule i created. How can i call the expression rule within webapi to validate API for errors,Is anyone have done similar requirement ,if yes please post code snippet for us. thanks a!startProcess( processModel: cons!PF_Create_Request_WithChanges, processParameters: a!fromJson( http!request.body) , onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( fv!processInfo ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json")

My code appears to be correct, however i receive the following error message when i change to design view. Error:   My code is the following: a!localVariables( local!DatosPedidos: a!queryRecordType( recordType: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos', pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data, local!DatosPedidosLineasPedidos: a!queryRecordType( recordType: 'recordType!{495578a9-1b23-4253-8145-6418faabe727}CPF Lineas Pedido', pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data, local!DatosPedidosRecepFiltro: a!queryRecordType( recordType: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos', filters: a!queryFilter( field: 'recordType!{3c95c0e4-e69d-43f6-b485-e72b24252af7}CPF Maestro Pedidos.fields.{eeea3ae1-9516-46e3-8caa-327a9154b43d}recepcionado', operator: "=", value: true ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) ).data

Hi  I need to download multiple files in one zip file from a web API, I have multiple Document IDs so I need to download them all at one in a Zip format.

Hi All, I have a query regarding date field validation. In my case i want to put validation on date field when user have existing date value and if user clear that existing date value at that time i want to show a validation like, date field should not be empty. for this i have applied may conditions but it fails because of the limitation  on validation property which says: "Validation errors to display below the field when the value is not null."            so i want that validation, only when user clear the existing value from date field. below is my code can any one help on this? i have one variable in which i am getting existing date.

Hi All, The requirement is that we do get a time value with time zone in a CSV in text format (ex: 12:00 CET), which we read and display on UI. When displaying the time on the UI we need to display it in GMT. With the current datetime functions this seems to be difficult to achieve. Other thing in mind is that maintain a table with time zone off set values for different time zones we get and use it to calculate the correct display value. This has its own issue like day light saving adjustments. But before going into that route we need to find if we can still do this easily programmatically.  Any advice is appreciated. Ex: Time value received in CSV : 12:00 CET on UI we need to display 10:00 GMT

here in richtext editor, on click of save values should be null, but after saving the values to DB again can see the values here.  on click of save values should store to DB and on UI it should not show - how can I achieve this?

Hi, Sometime the send Email smart service is taking huge time for sending an email. Please provide some suggestions for troubleshooting. Thanks, Preethi

Hi  Team,I am having use case where we are using IDENTITY feature available in Oracle in substitute of Sequences. and it is working fine from database insertion. But Appian is still expecting sequences.I went through few of the posts regarding  the same but there is no solution available rather than using sequences.I wanted to know if Appian is upgraded with the similar feature ? Anyone has used any strategy to accommodate the IDENTITY change ?Any feedback help is appreciated.

I m getting error in Execution log . Script ran successfully but in execution log getting errro message. pasted below.Thank you in advance.

Does anyone know if the advanced call web service app market plugin supports SSL Client Authentication?    The documentation indicates is supports ability to call secure HTTPS services that use a self-signed certificate but unclear if that is the same thing as SSL Client Authentication.    Thanks Bob

Hello everyone! I'm in the process of designing a quiz feature, and I'm struggling with designing an algorithm that will choose questions for a quiz. I believe my issue would easily be solved with a while loop, but since this is unavailable in Appian, I need some help designing an alternative solution. I have no code written, so let me describe my issue from a high level. I have a table containing quiz questions - around 400 rows at the moment. When loading a quiz form, I need to pull randomly chosen 40 questions from this table. First, I determine the first available question ID. Then, I determine the last available question ID. I save both as integers, 7 and 403. Then, I get a random integer number, picked from a range between 7 and 403. And here's where I get stuck: I need to make sure these numbers are unique. Normally I would have an array that I would append with these randomly generated integers on the condition that they are not already in the array, and I would do

Trying to save records ID back into the process variable when doing 'Write Records' but it's deleting the data of de process variable and only saving it's IDs. Any input on what I might be doing wrong? Is this normal with the write records node?

a!forEach( items: pv!id, expression: a!save( rule!Test_getDossierByDossierId( dossierId: fv!item, pagingInfo: a!pagingInfo(1, - 1) ), pv!id ).data)

Hi! I have created a process model in which a validation is needed depending on the group of the user In this case, if the user is from the group "CPF Proveedores", a validation Interface should appear as a task for the users of the group "CPF_Gestores". In order to fulfill my objective, I configured the User Input tnterface In order to fulfill my objective, I configured the User Input task this way: It works properly, and the task can be shown in "Tempo" for the Gestor1 (OK). But this "forces" the user to go to the tempo site, and I would like to show him that he has a task in a summary view of my site, for example. Which approach would you recommend me as a best practice? Is it possible to create a button to link with tempo? Maybe a link in one field?  Any opinion to define my approach would be useful  Thanks a lot