Extensibility

Hello guys, I have a page html and I want call web api appian, but retrivied this error: can you help me? thanks

Is it possible to read a password protected excel? I tried using function readexcelsheetpaging() as below readexcelsheetpaging(  excelDocument:<<doc>> sheetNumber:0, pagingInfo:a!pagingInfo(1,-1),   password:"ABCD@1234") However, I am getting error: Expression evaluation error at function 'readexcelsheetpaging': 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=3,v=ABCD@1234] as java class java.lang.Integer.

Hello everyone, Is there a plug-in, or an option in Appian, to implement a RFC 3161 Protocol compliant external Time Stamp, when applying a Digital Signature to a PDF document? The Timestamp should be embedded in the PDF document itself. There should be a possibility to choose the Hash algorithm which can be one of the following: SHA1 SHA256 SHA512 MD5 Any help is appreciated.

Hi,We are getting below error when trying to read document from MFT folder. It was working fine and suddenly breaking.[Appian Work Item - 245513 - WorkID 6 - execution02 - process 537248294 - model 8379 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=536905115, classname=com.appian.ps.plugins.sftpsmartservices.ReceiveFileOverSFTPBasic java.lang.StringIndexOutOfBoundsException: String index out of range: -1Could you please help me here?

Hi all,  May i know how to extract data from an xml file Thank You In Advance

How to retrieve the sign document back to the appian

Hello All, My requirement is client is sending an csv file to Appian which we need to insert in Appian table. I am using "Import CSV to Database V6" smart service. But now client want to send the file with some header and footer. Can anyone tell me how to read a csv file in Appian which is having header and footer. In Appian we don't need to save the header and footer we can simply ignore that. But how to ignore that in the Appian because client is sending same file to multiple platforms, so we need to do that in Appian itself. Thanks in advance Regards Sahil Batra

I need to copy the First Sheet from an Excel Document and add the same to the new Excel Document as its FIrst Sheet. can you please suggest the best approach and the smart services. Note: The First sheet will contains the data, so it should not be altered while copying

Hi Guys, Please help me on the below! I need to import list users from excel to the process model and then add them to numberous group. Can you please help me on the same??

I have created a Connected System that uses OpenAPI.  I then created an Integration that uses the OpenAPI CS to call a User Authentication API that returns a service token.  That token is then used to authenticate  other APIs that are available for the application.  Every API must have the token referenced in the header in order to authenticate.  I am trying to create an Expression Rule that can be used as a wrapper to call the User Authentication API and return the token.  I would like to use this rule as the Header value when creating additional integrations for the other APIs so that the authentication can occur every time the integration is called.  When I test the expression rule, I get an error that reads: "The jsonText parameter must not be null or empty." Here is a screen shot of the Integration, which works when I manually insert a valid bearer token: Here is the expression rule that fails: It seems like the API is

Hi all, may I know, how to extract the xml data in an xml file Thank You

Hi all,What is the best way to reduce Intergration's execution time.  Time 4,153 ms Prepare: < 1 ms - Execute: 4,152 ms (Send|Wait|Receive: 3,925 ms) - Transform: 1 ms Thanks

Hi all, I notice that the HTML Display Functions plugin is not listed on the app market and therefore may not be supported in the future, but I'm sure that many of us have it deployed in our environments for one reason: the function ncolumntable(). For anyone looking to remove this plugin, I'm including here an expression rule that I wrote to perform a similar task, and it also has the benefit of having no limit on the number of columns. Given a list of column headers, a list of Dictionaries, Maps, or CDTs containing the data to display, identifiers for fields in the data (optional - if blank, a!keys() will be used to determine the list of identifiers for each row of data), and some optional formatting parameters, this rule returns HTML code to generate a table displaying the data. This expression rule has the following parameters: columnHeaders (List of Text) data (Any Type) columnKeys (List of Text) headerColor (Text) evenRowColor (Text) oddRowColor (Text) /*

Hi, I want to call a RFC interface by Appian but I just saw that only BAPIs are callable? Is this correct?  https://docs.appian.com/suite/help/22.1/Invoke_SAP_BAPI_Smart_Service.html#asapinvokewithcommit Is there any workaround?

Hi, I'm trying to configure an SFTP using third party credentials but when I click on test connection in the Admin Console Third-Party Credentials  I'm not being able to connect, has anyone connected to an SFTP that can share details on how to connect using Third-Party Credentials?, I'm able to connect using WinSCP

Hi All, I have an issue where CSV To Excel node (Generate Excel from CSV smart service) on the pm is not generating the excel file so the import is failing. Below is error log screenshot. Quick help is much appreciated. Please let me know if any further details are required. Thanks in advance.

Hi, I have a question I am using LDAP Tool to get users from AD and automatically create their profile in Appian.I am facing one issue which is in AD there are few fields which are not correctly coming in Appian profile. for instance user manager is not coming even though I have mapped AD "manager" attribute to "User Supervisor username " Appian field. below is the screen shot of LDAP User Profile Synchronization process model input node. also for few users state is not coming and few custom fields are also not coming ?

Good day,I have some APIs that do operations over the resource 'User', and the following ones are needed: GET users - To retrieve them POST users - To create them PATCH users - To update them PATCH users/disable - To disable them PATCH users/enable - To enable them The problem is that I can only have one combination of endpoint vs method, so when I try to declare the second PATCH user API to specify the path to "disable" or "enable" I receive and error.My question is: what's the Appian way for doing those APIs declarations using the Restful pattern?Create only one web API object switching between each different path?Let the endpoint be empty, and put all the URI in the path field?Other options...Thanks for the help in advance

Hi , Does anyone have experience with using Sign PDF plugin and display timestamp information in singed document? BR,Natasa

Hello All, I am using the smart Service "Import CSV to Database v6" for saving the data to my Appian table. I have tried with multiple columns and with single column also but getting same error. Error Message:- java.nio.charset.IllegalCharsetNameException: Sharing the    Please help to resolve the issue. Thanks in advance. Regards Sahil Batra

Hello Team, We have a WebAPI that needs to be accessed from external system with Oauth 2.0 authorization. For this we setup Web API Authentication in Admin Console and got the Service account, Client ID, Client Secret, and Token request end point.  When setting up in Postman to test this out, not sure about what to use for the Callback URL and Auth URL - see attached.  [View:/cfs-file/__key/communityserver-discussions-components-files/18/PostmanSetup.pdf:320:240] Any pointers how this can be setup properly to test the WebAPI call from Postman? Appreciate in advance. Mahesh 

Hi , We have a requirement with the third party(old system) to have csv with comma delimiter delivered with data enclosed in double quotes. Below is sample data: Data in Database table: column1 column2 column3 testdata11 testdata12 testdata13 testdata21 testdata22 testdata23 Expected export of csv by third-party should look like below "column1","column2","column3" "testdata11" ,"testdata12" ,"testdata13" "testdata21" ,"testdata22" ,"testdata23" This was not possible 2 years back with smart service "Export Data Store Entity to csv" so we ended up 1. creating an expression rule that queries data from database and concatenates data of each column and each row with double quotes. 2. generate a text string 3. pass the text string to "Text doc from Template" smart service that creates a csv as expected by third party But the problem is as the data keeps growing ,

Hi, I am trying to use readexcelsheetpaging(), it shows totalCount value but not retrieving any data *note: the excel is generated using export to excel smart service what may be the issue, is there any work around?

hi I was able to make the connection between google sheets and appian, using the google sheets connected system (vuram)... i want to store the data of my appian cloud database to a  google sheets, is it possible? this is the integration that i have creates, connection successfully

I have created an integration s shown below: I am able to run this integration when values are null however, it is giving the below error when I give any values: sample request body with values: { "range": "Sheet1!A2:B2", "majorDimension": "ROWS", "values": { {"ABC"} }} Error:  The external system did not understand the request error-result-guidance The request was missing required details or was improperly formatted HTTP/1.1 400 Bad Request