Extensibility

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

getapplicationprocessmodelsuuids() this will give us the complete list of all process in a specified application. looks like its no more working. Can someone please let me know the equivalent for the same.

Hello, We need to get message from Blue Prism integration after integration call is successful.  When we call integration directly in integration object we get response in raw response like this: "<soap:Envelope xmlns:soap='schemas.xmlsoap.org/.../' xmlns:xsi='www.w3.org/.../XMLSchema-instance' xmlns:xs='www.w3.org/.../XMLSchema' xmlns:soapenc='schemas.xmlsoap.org/.../'><soap:Body><Message xsi:type='xs:string'>Successfully completed process</Message></soap:Body></soap:Envelope>"   But, when we call integration using call integration smart service in process model and try to save response we get empty result: [] saved in process variable.  Is there a way to get the raw http body while calling the integration smart service so I can parse it manually?

How to get the signed document sent using send document for e-signature docu sign back to appian.

Hello Everyone, I am creating a Web API (GET method) and am using a!queryprocessAnalytics to get some values from a report. One of the column in the report is Asignee and the type/Formatting for this column is 'User or Group Name'. When i test the request i am getting a valid result but with either Group Id or username. I want to first know if the value is User or Group then convert it into First Name, Last name for User or Group name for Group. I tried using find("[",cast(3,value),0) to know if the value is user or group but after knowing i am not able to convert the value to First Name, Last name for User or Group name for Group. Please help me to find a solution for this. Thank you

I just downloaded and imported the https://community.appian.com/b/appmarket/posts/adhoc-collaboration application plugin and couldn't find the below components: ACC_API_compactView ACC_compactTaskDisplay ACC_compactCommentDisplay ACC_API_queryEntries ACC_API_createNewEntry ACC API Create New Entry process model ACC API rule folder Can anyone help me with this?

Hi Everyone, I have a requirement to combine all excels having each sheet into a single file which contains multiple sheets together. I assume the combine excel sheet plugin will work but I am not getting the output document stored in the folder. Can you please suggest how to use combine excel sheet plugin? Thanks in Advance!!!

Hello, we're attempting to use the "Word Doc from Template" Smart Service on a Merged word document, but the smart service only replaces the placeholder from the first document that was merged. For example if we have 3 docs with placeholders, merge them, then run the Word Doc from Template Smart Service, the output document will only have replaced the placeholders that were contained within the content or the first document. We've checked all of the formatting of the placeholders in the XML and everything looks correct. The issues aren't caused by what's outlined in this KB document. Any idea what might be causing this? Merge document plugin community.appian.com/.../dynamic-document-generator

Hi Team, after update to 22.3 all our create user smart services with i18n are failing with  below error in UI as it is chained activity  An error occurred while executing a save: java.lang.NoSuchMethodError: com.appiancorp.suiteapi.personalization.UserValidationUtils.isValidNameLength(Ljava/lang/String;I)Z Is anybody found the route cause ? even the node is failing with below error . The amount of time allocated for the completion of an unattended activity was insufficient to allow the activity to complete Commented on below link as well ? community.appian.com/.../personalization-utilities

If I'm using a deprecated smart services, how can I check it in my app if I'm using it? For example: Export SQL to Excel and [Deprecated] Export SQL to Excel What would be the difference? Would you throw me any warnings or errors?

Hi, I am trying to create an Integration object in Appian. How can I make these parameters dynamic based on the environment. I would like to pass different parameters based on the environments like DEV, UAT and PROD. All these environments will have different urls. How can I achieve this.

I am having difficulty utilizing the "Connected System" and connecting to the Appian DB. I have verified we have a Maria DB and that the database name is Appian.  I think I have the server name correct, but not 100% sure. Would the server name be the same as the appian website.... companytest.appiancloud.com:3306? I know it is already available as a Data Type "Topcat" but I am trying to execute a stored procedure on the DB. Thank you

Hi,I've been assigned on creating a dashboard which includes showing all the Logs that are executed in the integration..As we can see.. once put check on the integration object the "Enable HTTP request/response logging for this integration object" and we clicked on test request in the integration, it is saved is the system logs>perflogs> http-request-and-responses As for my task, I need to get details from it and save it in appian DB. For POST method:I've managed to get a workaround on this by going to the PM's that were used to execute post integration and just added "write to datastore" in the flow for storing it in the DB. For GET method:I can't seem to find a way on when get integration is executed. I've used smart service also like a!startprocess etc. added in the handler of the get method and it just won't work since we cant run smart service on get method.Do you guys have any suggested workaround for getting the Integ

Any integration function there to over come this challenge 

Hi I want to filter my data by the field: "provienceID" (image bellow)  in my integration I create a rule input (number integer) The idea is, when I change the test values in the expression, I test with 1 and the result will be all my data with the "province ID" with value 1. I use this expression in query parameter section, but it doesn't filter by the values that I want, it gives me all the values For example for "province ID" with value 1 must show me just 15 fields a!query( filter: a!queryFilter( field: "provienceID", operator: "=", value: ri!provinceID ), pagingInfo: a!pagingInfo(1,-1) )

Trying to read the emails from Gmail account using "IMAP", but found no solution.

I have multiple excel sheets and can I assign the which sheet number to open(as Default) when I open excel after download.