Extensibility

Requirement is to display single color for first bar in each row and for 2nd bar in each row it show change dynamically as per status of the field. We are trying implementing timeline chart for one of the use case in which it should display 2 Bars in each row. One bar's color is fixed and another should be changing based on status. But when we try to implement logic then color is not coming properly using colors{} inside timeline chart. Output is not coming properly. Using two different loops for two bars in each row but it's not reflecting in the chart : googleTimelineChartField(chartColumnData: {{type: "string",id: "Name",rowDataKey: "name"},{type: "string",id: "Title",rowDataKey: "title"},{type: "date",id: "Start Time",rowDataKey: "start"},{type: "date",id: "End Time",rowDataKey: "end"} },chartRowData:{a!forEach(items:index(local!ccatAssesment,"data&q

Has anyone experience with Connecting on premise Dynamics CRM system with Appian Cloud instance ? Can it be readily done ? If not what are the pre-requisites to be completed . The On-prem system moreover is on local ADFS authentication.

Hi everyone, When I exported data using "Export Data Store Entity to Excel" from a proprietary Excel workbook that contains formulas, the Excel formulas get corrupted. Is there any limitation on the Excel workbook version that can be used with "Export Data Store Entity to Excel"? I am using Excel 365. Symptoms: (1) Formulas are shown as text and no longer calculated, for example:_xlfn.VSTACK({""}, _xlfn._xlws.FILTER(category!J2:J1001, TRUE, ""))IF(A9=0,,SUM(A9:B9))(2) Japanese phonetic (furigana) information appears in the same cell.

I have found information regarding a 5MB limit when my Appian application uses an Integration Object to call another API hosted on an external system. However, if my Appian application is exposing a WebAPI, so that an external system can make a GET request to my Appian application, is there a size limit on the JSON payload that my Appian WebAPI can return to that external system?

I have a webAPI which will receive the document from external system in binary format, but for file size around 25 MB, the API is taking more than 25 seconds.Is there any way we can increase the API performance by reducing the time taken by it?Thanks in advance.

In http response I am getting IDs and codes. Each id will have multiple codes. now i need to store the code with respective Id in table. How to do it?

i am trying to create a data store , i have already created teh data type and i can see teh field from database , The data source schema does not match the type mappings: Schema-validation: missing table [`xxxx_LIST`] (APNX-x-xxx)

what is the maximum limit of data that an integration call can retrive/query/ get  in vice versa .., How much (what is the maximum limit) of data we can expose to the external systems (when using WEB API's), where we can configure/ set these data limits

Hello Appian Community, I'm experiencing a URL encoding challenge with query parameters in an integration and would like to know if there's a solution or workaround. The Problem: I need to pass query parameter values that contain spaces (e.g., "North America") to an external API via a GET request. When I use Appian's standard Query Parameters in my integration object, the spaces are encoded as + signs, resulting in ?searchText=North+America. However, the external API we're integrating with does not recognize + as a space character and requires spaces to be encoded as %20 (i.e., ?searchText=North%20America). What I've Tried: Pre-encoding the parameter with substitute() - Replacing spaces with %20 before passing to the integration causes double encoding, resulting in %2520 because Appian encodes the % character itself Using urlwithparameters() function - Still produces + encoding for spaces, which follows the application/x-www-form-urlencoded standard Stand

Hi Team, I’m encountering an issue while uploading a file as part of the integration. The upload works fine for PDF files, but when I try with a .rtf.gz file, I receive a 403 Forbidden error. Interestingly, when I upload the same file to the same URL using Postman, it works without any problem. Could someone please look into this integration issue and help me resolve it? Thanks in advance.

Hi everyone, To avoid ambiguity: my input is an excel document. The relevant sheet is the first sheet (index 0). In that sheet, the first row is completely empty, and the header starts on row 2 (e.g., A2, B2, …). When I try to read the data with readExcelSheetPaging(), Appian seems to interpret the sheet as empty and I get: List of Variant - 0 items Example Code: a!localVariables( local!excelData: readexcelsheetpaging( excelDocument: ri!excelInputFile, sheetNumber: 0, pagingInfo: a!pagingInfo( startIndex: 2, batchSize: 10 ), stopReadingAtFirstBlankRow: 0 ), local!excelData.data) What I have tried so far: Using the remove() function to remove the first row does not help. The empty row is removed but Appian still returns 0 row, interpretating the sheet as empty. If I modify the respective excel Input file sheet and put any dummy value in "A1", then the exact expression works as expected and returns data from row 2 onwards. In that case, removing/skipping the

Hi Appian folks, I am getting this error on Export SQL to Excel smart service - "The following error was raised by the Export SQL to Excel function:  Name is insufficiently unique". I have configured "Document_name_to_create" on this node by appending now() after the document name i.e. "Document Name " & now(). I understand that this error comes up when document name is not unique, although I have appended now() in the end, the error doesn't seem to resolve. How do I fix this issue?

I am raising an issue with the Plug-in called Advanced Rich Text Editor (component: richTextEditorField) which is not loading or displaying to some users in some browsers from last few days, I am using it from last few months, but this issue is occurring from last few days!In appian environment the plug-in version is 1.7.3

We are looking for connect our appian with on prem oracle via jdbc. We are trying to understand the error, but the suite/logs result in 403. There's another way for read it? We cannot have a troubleshooting without this kind of information.

Hi everyone, I’m facing an issue while trying to open an Integration Object related to SharePoint in Appian. Whenever I try to open the integration object, Appian shows the following error message: Il sistema ha rilevato un errore Codice HTTP: 500 APNX-1-4198-000 Errore durante la valutazione dell’espressione UI Errore di valutazione dell’espressione (evaluation ID = YGR65): com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException com.appiancorp.suiteapi.common.exceptions.InvalidUserException Important details: This issue happens only with SharePoint Integration Objects Other integration objects open correctly The error occurs while opening the integration object, not during execution The connected system is already configured in other environments works just fine,only in test and dev environments give this error Has anyone encountered a similar issue with SharePoint integrations? I’d lik

Normal http get integration. Getting below error and clearly query url is not created  . It is working with bruno/postman. hardcoded the bearer authorisation token into the appian integration , getting the same  error as below HTTP REQUET Note: The HTTP request did not include the following headers because they contained empty values: Authorization Accept X-IBM-Client-Id Content-Type Headers with empty values will be included in the request. Test again to see the results. RESULT error-result-label Connection timed out error-result-guidance The integration execution time exceeded the configured timeout Next Steps Retry the request later Set the timeout to a higher value

Hi  I need to pass document as a base64 string to third party integration and the structure is as a nested cdt. I did configure everything correct in cdt and passed cdt as a integration body. But I'm getting a timeout error.  Could anyone faced similar issue? When I did check on request, Appian is converting into xml code, and it's adding <n> to the xml. For example <n1: OlUploadDocument></n1: OlUploadDocument> But it should convert as <OlUploadDocument></OlUploadDocument> and when I remove this <n> and sending it as a body in postman it's working. I was thinking is it because of extra <n> in the structure? May I know, how to overcome? Please let me know Thanks

Hi Team, We have custom registration plugin and we used to for our registration form, will show first and last names and email of the user and a captcha to verification then will allow to submit the button. Now, we are facing issue that input fields and some content in the page is no longer visible in the registration form. Could you please update me if you have any idea . Regards, Sireesha

Hi Everyone, I’m working on the Deployment API export action and am encountering an "Invalid API Key" response. When i make a Deployment API POST call to Environment-A from Postman and Environment-B(Self-managed cloud), both are returning the same error: Response: 403 - Invalid API Key Message: "Invalid API Key. Contact your Appian system administrator to obtain the proper credentials." Error Code: APNX-1-4552-001 Here’s what I’ve checked so far: Admin Console: I reviewed the web API authentication page (/suite/admin/page/web-api-authentication), and I noticed that the last used date and time are populated. Login Logs: I also checked the Login-audit.csv file, where I can see an entry showing a successful login for Web-API service account. Does anyone have any insights or suggestions on what might be causing this issue or how I can resolve it? Thanks in advance!

Hi, I am getting the above duplicate data on the right side part of the screenshot as mentioned in the screenshot within the excel cells that are not mentioned with in the cdt to excel plugin smart service config. Can anyone provide the reason why this might be coming up.

Hi , Getting the below error when testing my integration. Can one of you help me out if i am missing something ?

I am looking for advice on automating an access verification step in Appian. Each time a user logs in via OIDC, we need to call an external endpoint to verify their access. The endpoint requires the user bearer token issued at login, and we can only reliably perform the check while the user session is active. Because of this, we cannot defer the verification to a scheduled job. Is there a recommended Appian pattern to run logic immediately on login, so we can call the endpoint once and persist the user’s access in an Appian table. The goal is to avoid invoking the external API on every site page load. I tried using a service backed record, but it still requires a trigger such as a record view load. Similarly, a process model still needs a user action to start. Are there any platform supported options for a login hook, post authentication trigger, or another best practice approach to achieve this Any guidance would be appreciated. Thanks

Our Appian application serves multiple geo regions (NA, EU, APAC). Each region uses a separate DocuSign account—and DocuSign’s REST endpoints require the accountId in the path (e.g., …/accounts/{accountId}/envelopes). We also need to route to the correct base URI for each account/region. Goal: Make the integration scalable and configurable by: Using an HTTP Connected System so we can manage auth/base URL centrally and pass accountId as a rule input in each Integration. Dynamically selecting the correct base URI (per account/region) via DocuSign’s /oauth/userinfo (then cache it) or from the Apps & Keys page. \ Planning a future switch to JWT Grant so the integration runs with a service account (no interactive login), impersonating a user with consent.  Is it possible to implement the solution. If yes what are the limitation?

Hi All, I am getting this error after upgarding the SFTP Functions Plugin version from 1.7.0 to 4.1.1 -  Error copying the Appian document to the remote server. See application server log for more details. Error Message: Permission denied Can someone please advise urgently what changes are required to use this upgraded SFTP version. Regards, Nirupama

I'm using the Microsoft Document Editor Helper Servlets and Functions advanced plugin to display editable Word/Excel/PowerPoint documents from our Knowledge Center in an interface via microsoftDocumentEditorField().However, a failure popup appears when users try to open/view/edit the document (screenshot attached for reference).Please suggest the possible steps or configuration changes required to resolve this issue?