Extensibility

I need to authorize the user against Azure AD every time he click on a save button. I am able to authorize for the first time using a!authorizationLink via the connected system with OAuth 2.0 Authorization Code Grant. This authorization is active for 15 mins (because the access token may be having an expiry of 15 mins.) Now, all the sub-sequent integration calls are getting authenticated for next 15 mins but I want to restrict it and force the user to re-authenticate again and always (whenever he clicks on Save button) via the connected system and a!authorizationLink. Any thoughts would be a great help. TIA.

I am currently using OAuth 2.0 code grant authentication to connect to external system. I am able to generate token as pass it as an authorization header to the external system. But the problem is I am using connected system to get the access token but after the successful authentication i am getting id_token and access_token in the response. I am supposed to pass id_token as an authorization header but access_token is being sent as authorization header.  Help is appreciated. I am looking for any of the solution below or new option 1- How to extract connected system response into a variable? 2- Without using connected system how to generate OAuth2.0 token with Grant type as "Authorization Code". 3- How can I tell the connected system to pass id_token as a header rather than access_token?

Hi Experts, Earlier we were using Export SQL to Excel for generating the Excel from the db having 387 columns. This particular service has got deprecated, how can we get this undepreciated or if there is any other workaround to generate the same. Tried using Export Data Store Entity to Excel but it not working beyond 50 columns, when trying to break the colomn into set of 50 and then trying to right in next 50 column the previous column data is getting deleted.

Was not able to get the SharePoint connected system to work out of the box with client authentication.  I think this is due to a change on the SharePoint online side and I had to make some config changes based on this thread: SharePoint Online authorization issue 'Token type is not allowed' - SharePoint Stack Exchange Get started with the SharePoint Online Management Shell | Microsoft Docs Just FYI for anyone running into 401 errors. Maybe Appian can update the connected system and documentation to use an Azure Enterprise App instead of the old school SharePoint apps.

Hi,  For handling asynchronous calls from Appian, I have analyzed below approaches. Can you pls advise which approach would be suitable for below scenario? If you have any better solution, kindly let me know. Thank you in advance. Design summary: 1- Orchestration is carried out in Appian process model. There are three external APIs (Say A, B and C) that need to be invoked from Appian. 2- After calling API-A, Appian will hold the process flow 3- Once Appian receives response for API-A asynchronously, then it should move on next step 4- Same pattern follows for API- B and API-C  We have following solutions to accomplish this Asynchronous communication pattern. Solution-1: After invoking API-A at step#1 , flow moves to User input task to hold the process at Step#2 Response payload for the above call will be published to KAFKA topic at Step#3 from upstream system ( system for API A) Custom message listener ( JAVA based component ) will pick the response message from KAFKA topi

 I was using  plugin  getdatasubsetdownloadlinkfromprocess   to give export the data in excel to user on 1 click. Now its not working in 20.4. I also used a!exportDataStoreEntityToExcel() function but this need to work on 2 clicks it work in saveInto. Can anyone suggest any other method to provide user the export of dynamic excel. Thanks in advance

Has anyone received a 502 Bad Gateway response from calling a POST REST service via an integration and if so what was the cause and how did you fix the issue? We have an integration that calls an internal service to send emails from a corporate email account that can include attached documents. It works fine with an attachment of around 1.5MB but returns a 502 Bad Gateway response with an attachment of around 2.5MB. The service itself is tested with attachments up to 10MB. When we get the 502 Bad Gateway response there is no record of the request ever reaching the service endpoint (it's not in the service logs). The response body shown in Appian is: <html> <head><title>502 Bad Gateway</title></head> <body> <center><h1>502 Bad Gateway</h1></center> </body> </html> The integration is using the Automatically Convert CDT to JSON option to convert the attached documents to Base64 Any advice or suggestions to help

Hello, I have 3 Record types with different project statuses (In Progress, Closed and Deleted). For the In Progress and Closed record types I have an related action which changes the project status from In Progress to Deleted and from Closed to Deleted. Once the related actions returns back after completion the project doesn't have the previous status anymore and it cannot be found in that Record Type also. The message that I receive is:" An Error has occurred, The record data does not exist, has been deleted, or you do not have sufficient privileges to access it" thing which make sense. In order to avoid this thing I would like to redirect user to main site of the application in the same tab. (Appian version is still 20.4) I have been searching in all the topics but unfortunately no solution was found. Do you have any idea? Thank you!

Hi Team, Can we call the python scripts from Appian,I need to trigger it from Appian  We are using the cloud  Thanks, Udayasai

Is it possible to upload diffrent type of documents in upload document web api. i need to upload pdf ,jpg and png in a single API can anyone help me pls and can i pass a binary document into an upload document web API?

Hi All, We have a UI where we call a safe link to open an External UI in the same tab. This safe link can be triggered from multiple places in Appian (Sites or Tempo). A single user can have access to multiple sites or tempo from where they can trigger the safe link. Now on the External UI, we have to call a link (link will be sent to External UI using API) to navigate back to Appian from the original location, but the problem is we do not have the browser URL from where the user clicked the safe link from. So is there a way we can find out from which site/tempo was the safe link triggered?Eg -User is on Site A -> Triggers a process -> UI has safe link -> User clicks on Safe link -> Navigated to External SiteUser is on Site B -> Triggers a process -> UI has safe link -> User clicks on Safe link -> Navigated to External SiteNow how do we know that the user was on Site A or Site B as in Sites we cannot add any parameters while calling any processNote -&g

Anyone was successful in setting up SLO with Okta? I am successful in setting up SSO, but for SLO, okta requires a Signature Certificate. And no matter what I provide (like one self signed generated using openssl, or provide the godday cert for Appian), it is not working. It says Signature is invalid. Is there any pointers please?

I have written a code to be used as a appian plugin using C#. Does Appian supports C# language ? If yes, how can I deploy the code written using C# ? Or do I need to convert the C# code to Java code ?

I need to store original file name into database of the uploaded excel sheet. Please suggest if we have any smart service or plugin for the same.

Please suggest any Smart Service or Plugin to create copy of any uploaded excel document. The copy of uploaded excel document should have same formatting and tabs than the original document.

Do we have any plugin or smart service to modify the excel sheet without loosing it's formatting? We have requirement to upload large excel sheet with around 20k rows and modify cells values without loosing it's formatting. Keeping in mind that excel sheet have multiple tabs with formatted data and once excel edit done, formatting should not be removed in any of the tab.  We have tried Export database CTD to Excel to modify excel but it is removing excel sheets formatting.

Hi All, Tried triggering a process model via mail. The process model is throwing an error while reading the document using readexcelsheet(). The document comes as an attachment and is stored in a folder. Getting below error while reading the same. I have given viewers right to the folder as well. Started by Guest.

We have a requirement to find when a user last logged into Appian Env. We found a plugin which gives result if a user has logged into Appian within last 30 days else returns null. But clients want minimum 6 month period or 180 days past login data. Is there any Plugin or functionality to find out if a user has logged in within last 6 months or similar period of time

Hi All, I am trying to read excel data using readExcelSheet() function to read and transform the data into cdt type to right it into DB. With less data its working perfectly fine but when the amount of data increases server goes down while reading the data itself. I tried using Import Excel to DB smart service but it seems to have so many limitations. Is there any way possible to read the data and store it in DB. Note: File have 385 columns which are mandatorily to be stored. File size is from 38-100MB.

Hi All, Need help on how to read data from an excel file, if the relevant data can be in any of the sheets in the file? For readexcelsheet() if sheet number 'x' does not exist it would throw an error, so how to traverse through sheets?

IDp Source: AWS SSO, Accessing Appian app. as external application thru AWS SSO SAML authentication. Could you pls suggest how do we import / upload  the signing certificate in AWS SSO? I could not find any option to upload the certificate in the "Manage Certificate" section.  Is this something that we can't do in AWS SSO whereas this is allowed in Azure AD SSO. The AWS SSO certificate which we can download does not contain the private key. My SAML Appian SP application expects to configure SAML settings with private and certificate data in the combined . pem file. In AWS SSO, I'm unable to upload / import the certificate file that I've configured in Appian application. Does it means AWS SSO SAML authentication not compatible to integrate with Appian? We've managed to successfully configure and test this with Azure AD SSO. I'm trying for alternative approaches of integrating AWS SSO Idps with Appian app. Thanks.

We have an integration object that calls an API that returns a document. So far we only needed PDF so we hardcoded the extension to .PDF. Now we can also receive a TXT file that contains JSON data in it. What is the best way for us to dynamically set the extension depending on the document that we receive? The integration team added the Content-Type to the HTTP headers but when I remove the .pdf, the document extension is set by Appian to .bin. (The txt file is getting set to .json) Any recommendations on how to best implement this?

Hi Folks, Is there a way to cache the output which we are getting from the response body of a API. So for example if we are calling the Workday API to get the details of a particular employee based on his email id.So if I pass the same email ID multiple times individually in 1 hr or 2 hr period, I will get the same result from the Workday API . So instead of calling the API and getting the response, is there any way where we can store the response for some time period and in that time if  new request come for the same employee, then instead of calling from API , it will fetch it from  cache. So it's great for performace improvement. Regards, Ghanashyam

Using code similar to the following I'm finding that record user filters are not always clearing. |populate record type user filter|Filter1|with|Value||clear record type user filter   |Filter1           ||populate record type user filter|Filter2|with|Value||clear record type user filter   |Filter2           | Watching the script execution I can see that the field is focused and FitNesse tries to do something the clear fails. Sometimes it throws the following error "clear record type user filter An error has occurred: User Filter" but there is no more details on the cause FitNesseForAppian Release v20.2.1FitNesse Release v20200501

Hi All, Below is the issue we face while usinf SFTP plugins. The SFTP smart services are used in the application to receive files and post processing remove these files using Remove files over SFTP smart service. The process runs daily thrice where the files are picked up from different folders. The SFTP credentials , host , port used are same for all folders. Initially , in production all the folders did not have files at the same time. The files came in at different times so the scheduelers receiving the files and its removal were not impacted. Now a new folder is added and the files come into these folders at the same time and the process model instance runs simultaneously for 2 folders and thats when the error occurs. Even though the PM errors out at the Remove files over SFTP with the error as - 'Error removing file in the remote server. See application server log for more details. Error Message: Specified file path is invalid. '. Actually the files are remove