Discussion Categories

We have what is effectively an API broker or proxy tool between our Appian instance and an API we consume.  The broker/proxy requires API Authentication to properly identify our system and allow access to the API's that it brokers.  It does not however leverage it's own API keys to the services it represents.  As a result, we have to pass a second API key through as a header.However, I have security concerns about the storage and security of this second key. Has anyone had experience and advice to secure this secondary key?  It appears as clear text in the request headers,  must be available in the integration or connected system (unlike the primary API key - which is masked and unreadable in the Connected System), and I cannot use the secure credential store to secure it.  Even if I store it in a constant,  I'm concerned about the potential security. Advice greatly appreciated.

Hi, I have a decimal field on my interface that I want to colour based on its value..something like if =8: then green if <>8: then blue How do I do that??  I know how to colour a text field. Please help thanks jaideep

Hi, Is there a way I can see on Appian logs as to who has made changes to the data.. for eg.. who created a certain record, who updated it, who deleted it and so on.. i tried looking for this info in tomcat-stdOut.log but cudn't get.. or do I need to create/code my own history table where I should track these user actions? thanks in advance jaideep

I have implemented service backed record with daily sync enabled. But the data at the source(service) gets added frequently(in minutes) and the customer want to see the updated data in Appian once its get added at the source. I have gone through documentation where I saw "Sync Changed Data". Could someone help in achieving "Sync Changed Data"? Additional Information: 1) Identifiers of the data being returned by the service are not sequential but random in ascending. (Identifier's are unknown if I need to use "Sync Record" smart service) 2) Full Data Sync takes around seven minutes. (for now there are around 180K records being returned by service, in prod it will be around 490k and will increase)

how can we achive pagination in layout grid without using foreach?.

Hi On my process modeller, whenever I debug the process model, the Process Start Form does not display, the process continues to the next steps without the option to populate the form. Is there a setting for enabling and disabling the Process start form or is this just in my environment? Thanks in advance

I ran into small copy and paste typo in Appian 22.3 docs. Don't know where to submit this, I know it's not really a question. Hope someone can route this to right team correct it.  https://docs.appian.com/suite/help/22.3/Oauth_connected_system.html  https://docs.appian.com/suite/help/22.3/oauth_client_credentials.htmlIn this case it think it should mention Client Credentials Grant instead of Authorization Code grant. 

Hi, can anyone teach me how to retrieve the week range based on the weeknumber and year. For example, the user selects a date. I use the weeknum(ri!startDate) already retrieve the weeknumber and the year(ri!startDate), so I already have the weeknumber and the year already, how to retrieve the date range from the week number and year ? such as 11/11/2022, week number is 47 and the year is 2022,  how to we retrieve the date range like " 7/11/2022 - 11/11/2022 ? anyone can help or assist me [emoticon:c4563cd7d5574777a71c318021cbbcc8]

Hi All I am currently working on version 22.3!! I have a use case wherein one of my current process is started when an external system sends email on the process model id i.e.: processmodel<id>@companydev.appiancloud.com( here dev represents the Appian environment). The requirement is that:The system can receive external mails using company's SMTP i.e. @company.com rather than @companydev.appiancloud.com.  Would like to know is there a way I can do this? I have read the the topic "Legacy configurations" in the link below but I am not able to understand what does reply-to-address means and will it even help me in my problem: https://docs.appian.com/suite/help/22.3/Sending_an_Email_Message_to_a_Process.html#starting-a-process-using-an-email Thanks in advance!!

I have a string "a,b,c" I want to convert that to array of string.

Hi everyone, I'm having above error message after using a!todatasubset(), my code is as below:  local!pagingInfo: a!pagingInfo( 1, 1, a!sortInfo( field: local!emailsRelatedToCase.id, ascending: false ) ), local!datasubset: todatasubset(local!emailsRelatedToCase,local!pagingInfo ), within that, local!emailsRelatedToCase stores data queried from a database to get email IDs and relatedCaseId, sentFrom, sentTo, dateTime for each email. Did anyone see this error before? Thanks a lot,

hi,  I have built a bar chart with a simple measure of SUM of time but when I put the labels I see a value like 47.9499999999999996 I have checked the issue is not with data.. I do not have that kind of data. I have a solution that I round off the the time taken, store it in another variable and use it for SUM and it works.. but I cannot individually round off the time field.. the overall data deviates a lot. All I need is to round off the above data to 47.95 .. when I see the expression generated by the MEASURE function on the chart I see Is there a way i can modify this expression so that it returns a value upto 1 or 2 decimal places.. I tried using round func in this expression but that's not working thanks much  jaideep  

Hi Team, During our performance testing, we are getting below error . when manual testing we are unable to reproduce it ,  Expression evaluation error [evaluation ID = c5310:d3811] in rule 'dsm_getslariskcasescount' (called by rules 'dsm_d_dashboardreport' > 'dsm_recordsyncbasedhomepagemain') at function a!queryRecordType: APNX-3-0000-002: The real-time store is not up to date to the requested tx 102138493; latest tx is 102138487 (APNX-1-4198-000)

hi, I want to Complete the empty space to save space, what are the best practices?

I have a read-only grid which should show all the rows with filter (isResigned) when I open the report. Along with that I have pie-chart in the same report based on last working date. So, now when I click on pie chart the read-only grid should be updated based on my selection.  I am able to get the full report with filter isResigned but when I select the column the read only grid is not getting updated.

On the process minning install documentation (https://docs.appian.com/suite/help/22.3/pm-5.6/admin/install.html) in the Production installation section step 6 says: Modify the following mandatory parameters in the .env file Shouldn't it be .env-prod? and if so step 6 should be merged with step 5. Because when you run ./pm.sh use-prod-config the file .env will be overwriten with the contents of .env-prod Thank you.

Hi, I have setup a timer to run "Daily" and "Every weekday" at 4 PM. This should trigger a email notification. But, I am receiving an email notification on every day at 5:30 AM EST.

After updating the plugin getting the following errors (Note: It was working fine in the earlier version) : Import CSV to Database v6  - Changed to Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'yyyy-MM-ddTHH:mm:ssZ', 'HH:mm:ss'.Snippet of Datetime format - "2021-12-10 14:20:42.740"    Load CSV File To Database (Using Out-of-Box Appian Datasource) - java.lang.Exception: This method only work with MySQL databases.

a!localVariables( local!data:rule!VG_CRK_RT_get_all_srvc_nm(), local!exportDocId, local!errorMessage, local!flag:false(), a!formLayout( label: "", contents: { a!sectionLayout( label: "", contents: { a!radioButtonField( label: "Select Any Option", labelPosition: "ABOVE", instructions: "", helpTooltip: "Before Uploading, Download a file for service, to view latest data", choiceLabels: {"Download", "Upload"}, choiceValues: {false(),true()}, value: ri!isUpload, saveInto: {ri!isUpload}, required: true, choiceLayout: "STACKED", validations: {} ) } ), a!richTextDisplayField( labelPosition: "COLLAPSED", value: { "Before Uploading, Download a file for service, to view latest data" } ), a!dropdownField( label: "Service Name",

how to validate a text field which can be  A,B,C,D, Null, or groups of A,B,C,D (ex. ‘A,B,C’ with commas no space).

Hello, I'm looking for a best practice how-to enable a user management within an application. Basically there are two main roles within the target application: administrator role - I assume that one can be based on the appian built-in user management standard user role - thats a role where an "anonymous" user can apply for with a self choosen username and password based on an application built login interface such user will have some additional things to do What would be a good way to achieve this if any? Thank you in advanceThomas

How can we generate a series of random numbers like 23434 56767 89789 34355 56307 Please suggest me or an example without any table connection

Hi Team, I am looking for a plug-in or Public Appian API or function to list all Folders in an Application including rule, process model, KC, document folders. I tried with below function which returned only the folders inside KC of an application when given searchCriteria with APP_PREFIX&*. Please do the needful findcontentbyattribute( searchAllContent: false(), contentType: "folder", attributeName: "name", searchCriteria: "<APP_PREFIX>*") Thanks, Bharathwaj RK

Hi Everyone , i want to extract pdf file data into database. if any smart service or plug-in is available in appian  ?  like: ( we have importfromXL to XL files ) please suggest the best way to achieve this. Thank you