Extensibility

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

I ma trying to generate a new excel file with a dynamic table based on a template, I already tried passing a html table like this with no success <table border='1'><tr><th>Name</th><th>Department</th><th>Experience</th></tr><tr><td>John</td><td>Accounts</td><td>3 years</td></tr><tr><td>Philip</td><td>HR</td><td>5 years</td></tr><tr><td>Adam</td><td>Networking Services</td><td>2 years</td></tr></table>   any help? note: I am using this smart service beacuse it keeps the styles and formats from the template.

Hi there, I have an integration calling a SOAP web service, returned result as the following ("Return raw response body"), how to extract the data circled by RED?  regards,

Hi Everyone, Is there any direct way to fetch the total no.of worksheets uploaded in the excel document and also what is the maximum limit of sheets that can be read in appian Thanks, Rakshna JG

Hi,  I'm trying to import Automation Anywhere features in Appian RWM. I followed the documentation, but I retrive an error message when I wrap the ETL Process model.  Please, could you help me?  Thanks in advance,  Erzen

Hi All, I'm trying to generate grid in pdf format using PDF from HTML, When Opening the html template in browser its working fine but the generated pdf is not properly aligned and text at the bottom are not even visible. Is this a know issue or do we have some workaround for this. Thanks, Ankita Singh

Is it possible to use OAuth to connect to Azure DevOps API? I saw another post saying the OAuth used by Appian is not compatible with SharePoint and wonder if the same holds true for the Azure DevOps API.

Hi all,I have facing issues were implementing googleGeoChartField in interface.Since googleGeoChartField not visible and not working.Here attached the code for your referencegoogleGeoChartField( mapApiKey: XXXXXXXXXXXXXXXXXXXXXXX, chartColumnData: { { type: "string", id: "Country", rowDataKey: "Country" }, { type: "number", id: "Sales", rowDataKey: "Sales" } }, chartRowData: { { Country: "Germany", Sales: 400, }, { Country: "United States", Sales: 1300 }, { Country: "Brazil", Sales: 500, }, { Country: "Canada", Sales: 1280, }, { Country: "India", Sales: 700, }, { Country: "Indonesia", Sales: 100, }, { Country: "Russia", Sales: 1000, }, { Country: "Mexico", Sales: 1000, }, { Country: "Australia", Sales: 1400, }, { Country: "Iran", Sales: 300, }, { Country: "Thailand", Sales: 100, }, { Country: "Laos"

We have used the plugin Move To Collab (v1.0.0) to copy files from filesystem to our knowledge center folder using the smart service provided by the plugin. However, we have observed that in some instances the smart service does not complete and the node is skipped resulting into process instance failure. The error is neither captured in process instance, nor in the server logs. The file path given as node input is a valid path (i.e., the file does exist at the given path). What could be the potential cause for this? Any help with this issue would be appreciated.

Is there a way to control the output color of the text when using the PDF fill Smart service?

Hi All, I'm trying to generate table in docx Using Docx From Dynamic Template. When trying with sample data and template as given below "<info> <rowvalues name = 'John Samuael' branch= 'CSE' rollNum= 'abc' /> <rowvalues name = 'Michelle Dsouza' branch= 'IT' rollNum= 'fgh' /> </info>"  Here its working fine and able to generate 2 row of data But when I'm trying to generate with actual data i.e as given below <info> <rowvalues name = 'Gaurav' dob= '4/1/2021' requestnumber= '1' /> <rowvalues name = 'Gaurav Singh' dob= '4/1/2021' requestnumber= '2' /> <rowvalues name = 'Shahid' dob= '4/2/2021' requestnumber= '1' /> <rowvalues name = 'Shahid Salman' dob= '4/2/2021' requestnumber= '2' /> <rowvalues name = 'Prachu' dob= '4/3/2021' requestnumber= '2&#3

Hello All, We have a requirement to re-authenticate a user from the SAIL form. When a user click on the submit button in SAIL form(After filling all mandatory fields), system should ask for their login credentials to re-authenticate them. Please let me know if there is a way to implement it in Appian cloud environment Thanks in Advance !

I am getting the following error when I am to insert on my table. Any ideas why?  the following data what is SCOPE_IDENTITY

I am getting the following error when I try to insert a new item to my Integrated DB An error occurred while trying to write to the entity “UMS_INTEGRATION_AAPP” [id=1af91040-2df8-4691-95b9-0a2d725ec112@11037, type=UMS_INTEGRATION_AAPP (id=4502)] (data store: UMS AZURE DS). Details: org.hibernate.exception.SQLGrammarException: could not insert: [UMSINTEGRATIONAAPPDT4539]: com.microsoft.sqlserver.jdbc.SQLServerException: 'SCOPE_IDENTITY' is not a recognized built-in function name. Data: TypedValue[it=4502,v={100054,<null>,111.0,111.0,111.0,111.0,<null>,<null>,<null>,<null>,<null>,<null>,Boston,New York,,,,,,<null>,<null>,<null>,<null>,<null>,<null>,<null>,<null>,<null>,<null>,<null>,2021-04-23 00:00:00.0,2021-04-23 00:00:00.0,Administrator,Administrator}] however I don't get this error if I try to update an existing item on the DB

If we upgrade a plugin to the latest version and we are using smart services related to this plugin in process models. How will it affect the process model? Will it automatically be reflected on the process model smart services or we need to update anything in process model as well?

Need to validate any uploaded document which is password protected, display message and not allow those if they are password protected. Please help.

I am trying to set up an AWS S3 integration using the Amazon S3 Utils plug-in. I have everything working except I need to give the plug-in the necessary credentials through the Third Party Credentials section of the Admin Console. Could someone let me know what should be in the "Test Connection" expression or how to go about testing that connection? Thank you

Hi All, I am using the PDF from XSL-FO smart service to generate a PDF.  I'm generating the XML/XSL docs for the smart service via expressions that query the database.  I'd like to let users enter text in a rich text editor, and have that rich text preserved in the PDF. For example, the user enters a list in the rich text editor.  The database value is something like <ul><li>item 1</li><li>item 2</li></ul>. Currently, my PDF generation just shows the HTML as the exact string <ul><li>item 1</li><li>item 2</li></ul>.  Does anyone know of a way to display the formatted HTML in the PDF?  The only thing I can think of is to build some expressions to generate the correct XSL and then strip the HTML in the XML.  Any easier approach?

I have an integration system with Appian and Microsoft Azure, however the client wants to have a default account to view the page with the records. My question is  is it possible to access Appian without the need of Authorization?  do you need to log in at all times to access Records, Sites  or Interfaces