Extensibility

1. Current setup we are generating the JWT token using and external system key and the details we are stored in the Third-party credentials in Appian admin console, and we are using the JWT token to generate the token, and this approach works well. 2. Problem The external system key expires every six months. This requires manual updates to the key in the third-party credentials in the admin console. We have access to a Realtime API to retrieve the external system key dynamically. Is there a way to generate the JWT token without manually updating the third-party credentials every six months I need to build like this, I have a process first I will trigger the API to get the external system key and I will pass the key and i have to get the JWT token.

Hello, I have a use case where I need to download multiple documents from SharePoint. Currently, I need to do this in a process model and the only way I have found of doing this is by creating a loop within my process.  Unfortunately, I need to activity chain this process and by having this loop, I risk breaking the 50 node limit. My question is as follows: is there any way to download multiple documents from SharePoint using a single node within a process? Thank you

There is a database table where user can write into. I need to generate a dynamic template using the data from the table. Meaning I have a button or a link, whenever user click it, the latest template should be generated and downloaded. 2. And I want one of the column to be populated with a dropdown and user can only choose value from the dropdown, which also means the excel should be protected. Can we generate protected excel with only specified cells that can be edited How can I implement this?

Hi, I'm using readexcelsheetpaging() to read an excel, it has a blank row so I want to set stopReadingAtFirstBlankRow: false But I got following error: Expression evaluation error at function 'readexcelsheetpaging' [line 26]: The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB was not able to produce a value for typed value TypedValue[it=26,v=0] as java class java.lang.Integer. But when I removed stopReadingAtFirstBlankRow it works fine.

Hi, When I was reading an excel file uploaded by user, how can I identify the max row that has values? Otherwise if I read to the row that has no values I'll get error, I'm using excelreadcellsbynumber()

I am trying to move the file into file system by creating a folder on the destination path. I am passing folder parameter using constant. This is moving file in file system but not creating folder. Please guide me what I should configure so that it will create folder and move file in it. ++[mention:9a3c4b933d674b319102bb3e59083770:e9ed411860ed4f2ba0265705b8793d05] 

Hi everyone, I’ve created a GET method Web API that returns a list of countries in the HTTP response. The Web API also includes a query parameter for the username. Now I need to log each Web API call by saving the endpoint name, response body, query parameter, and the current date and time into my Web API Log record. However, the issue I am facing is that Appian doesn't allow the execution of the WriteRecords smart service within a GET method Web API and gives me this error: Smart Services cannot be executed in Web APIs that have a method of "GET." Does anyone have any suggestions on how to handle this case without changing the API method to POST, PUT, or any other? I would appreciate any help. Thank you! For reference, here’s an example of my Web API code: a!localVariables( /* Retrieve all avalaible countries from the corresponding Record Type */ local!countries: a!queryRecordType( recordType: 'recordType!ABC Country', paging

I got 2 of this. one is Intergrate Designer and one is API Web designer. I already configured all the parameter and the endpoint seem the same from 2 of them. I use test request and both of them return success (200) but only Web API designer post data to database while Intergrate Desginer doesn't. Integration Designer :  Web Api Designer: Can anyone know what is the issue and how to resolve this one.

Hello, I have an issue with the map, which just won't appear in the interface. I had this issue a month ago, when I couldn't see the map, but my colleague did. A couple of weeks later the situation was the opposite (I saw the map, but my colleague didn't). Now the problem is worse - none of us sees the map...

Is there any way to show a loading animation like a loading circle instead of an interface while the integration is running?  For example my main site is built with 8 interfaces where one of the interfaces calls an integration that might sometimes be slower (can take up to 5sec to load). In the current version if I force the backend API to take longer to load and then try to load the main site the integration call blocks the loading of the whole page while the data is loading.  What I would optimally like to have is that all the other interfaces get loaded while the one that calls the api shows a loading symbol until the data is loaded from the API.  If anyone has any suggestions on how to achieve this please let me know.  Thanks, Jan

Hi Appian Community! Does anyone have good recommendations for replacements for the unsupported plug-in Republish Model as Different User? My organization uses it in lower environments whenever an individual developer modified a process model and daily, there is a scheduled process that republishes all the modified process models as a service account to prevent issues of process models being "stuck or frozen" when a developer leaves and their account becomes inactive. TIA

Hi,  I am running into this error  "An error occurred in executing an Activity Class."  while attempting to Export Data Store Entity to Excel (smart service). We are only facing this issue only in one of our ENV after upgrading from 22.3 to 24.2 (On-prem). I have checked to see if the PM and datastore is published, no strings are used in pointing the Datastore entity. Please help me understand this.

hello in our application we're using a!sapInvoke to query some data from SAP. the integration were working till last friday but from this week they're failing. here's an example code of one of this expressions: a!sapInvoke( scsExternalSystemKey: cons!LEASE_SAP_SCS_EXTERNAL_SYSTEM_KEY, usePerUserCredentials: cons!LEASE_SAP_USE_PER_USER_CREDENTIALS, hostname: cons!LEASE_SAP_HOSTNAME, clientnumber: cons!LEASE_SAP_CLIENT_NUMBER, systemNumber: cons!LEASE_SAP_SYSTEM_NUMBER, bapi: "BAPI_MATERIAL_AVAILABILITY", importParameters: { MATERIAL: ri!SAPcode, STGE_LOC: cons!LEASE_MATERIAL_STORAGELOCATIONSELECT_LOW, PLANT: cons!LEASE_MATERIAL_PLANTSELECTION_LOW, UNIT: ri!unit }, tableParameters: {}).result which is returning the error: Could not connect,message:Failed to connect to the external system [key=leasesapdev]. The site-wide credentials may be incorrect. Please ask an administrator to update the credentials in the Third-Party Credentials page in the Administration Cons

Hi! When I use an integration in a process model, I get the following error:The integration execution time exceeded the configured timeout.However, the service I invoke through the integration works fine, only the Appian integration gets the error even if it worked as expected. How can I fix this? Is there a way to give it more time so it doesn't get error by timeout?

I am looking to make some changes to the MS Graph Mail Poller plugin ( [mention:52a1e126f08841948bffc2d3bceb5e2a:f7d226abd59f475c9d224a79e3f0ec07] ) and came across an issue between 24.3 and 24.2.  The plugin makes use of the ContentUploadOutputStream class, which exists in 24.2 (https://docs.appian.com/suite/help/24.2//api/com/appiancorp/suiteapi/content/package-summary.html) but does not exist or is not accessible in 24.3 (https://docs.appian.com/suite/help/24.3/api/com/appiancorp/suiteapi/content/package-summary.html) and there is no mention of it being deprecated.  Along with that, the UploadDocument method on the ContentService interface still returns a ContentUploadOutputStream object (https://docs.appian.com/suite/help/24.3/api/com/appiancorp/suiteapi/content/ContentService.html#uploadDocument(com.appiancorp.suiteapi.knowledge.Document,java.lang.Integer)). It seems like this is a bug and the ContentUploadOutputStream class should stil

Hii Everyone, I am working on Deployment API - Inspect Package, i have created a connected system in which i have entered the base url as https://<domain>/suite/deployment-management/v2, where <domain> is replaced with my site domain, and use API key for authentication. Then i have created integration using this connected system with relative path as /inspections and in request body selected content type as multipart form data and created four parts adminConsoleSettingsFileName, packageFileName, customizationFileName and zipFile, for all this parts i have created rule inputs named same as the part names and kept type as text typeexcept zipFile which is of document type. I have passed the names of document in text type rule inputs and in zipFile i have passed exported applications zip file but now its showing error as shown in below image, can anyone help me with this?

Hello Everyone, We have a requirement to unzip/extract a .gz file, any ideas on how can this be achieved. Thanks

We have a third party system which sends a notification to one of our endpoints in Appian at random times and wont wait for any response from us. Our concern is that we will miss some of these notifications if Appian is down for an upgrade / maintenance as all nodes will become unavailable even if we are on HA config and there is no queueing OOB for Appian to capture these API calls (which does make sense as APIs typically needs to send a response back when ever called) I cant go to the third party system to create a queueing system and retry them after some time once Appian is available. I am looking for some ideas to handle this in Appian. 

I have created an integration to do the patch inspection using Appian Inspect api. I am expecting the ouput as uuid of the patch but I am not getting the proper output. I am gettting the below  shown response. The status code is 200 but I am not abole to convert the response into appian value. 

Hi Team, I have a requirement wherein in Appian interface after clicking on a link directly it will redirect to the Tableau dashboard on same tab or different one. Please let me know how we can achieve this. Thanks, Amita

When I am trying to use the adobe plugin onto on-prem env it is throwing below error: While with the same integration key it is working fine on cloud env. Does anyone  have any idea how we can fix this

HI ,I am using "Google Sheet Connected System"  to write data in google sheet . I am trying to write data in the different columns for example column is I & J so range and values are- Ranges:- " Sheetname&"!I2:J" "  values:- { "Text10@Text4", "Text2@Text5", "Text3@Text6"} but If i want to update the column T also and giving range :- Sheetname&"!I2:T" values : _ {"Text10@Text4@Text9","Text2@Text5@Text8","Text3@Text6@Text7"} In this case ,T column is not updating or writing anything.So Can anyone tell me that what will be the correct way to update or write in the google sheet.Thanks in advance

I have a file that have around 80000+ records and size is around 35MB. I would like to understand the way to read the data in it but need paging to be part of the process as i want this to be inserted into DB.

Hi All,   I have a template document where it has 3 statements and then a table which will display data . But if the data is empty, the table header is also not displaying . But I need the output doc to display the template. table with header row showing no data available. Is this possible, Please suggest some solutions. a!localVariables( local!queryXML: if( toboolean(ri!isFormat)=true(), ri!data, a!forEach( items: reject(fn!isnull,{ri!data}), expression: "" ) ), if( a!isNullOrEmpty(ri!data), "", if( toboolean(ri!isSplit)=true(), local!queryXML, ""& ""&ri!product&""& ""&rule!DIL_testNewDateFormat(date: ri!dateFrom)&" to "&rule!DIL_testNewDateFormat(date: ri!dateTo)&""& ""&ri!type&" listing"& if( ri!type = "Unblinded", "Unblinded Safety Data : Do not share with blinded study personnel", "" )& local!queryXML& "" ) ) )see attachment/resized-image/__size/640x480/__key/communityserver-discussions-