Extensibility

Hello All, We are using Sharepoint Smart Service to delete document from sharepoint. The api works fine with the delete operation if there is no special characters in the filename. But the issues comes when any special character is present in the filename and I get the below error. Kindly advice could be the ideal way to achieve the delete operation. SharePoint returned a 404 HTTP error error-result-guidance SharePoint returned the following error code: -2130575338, Microsoft.SharePoint.SPException The file /sites/DR510/Shared documents/Appian Test/Testing and Sub/12041/create#.xlsx does not exist. Thanks & Regards Girish Katti

Hello! We have an API to which user authenticates via basic auth. Is there any way in the Appian API object for me to access programmatically the user ID calling that API?

Hi Team, I have a requirement to define connected system dynamically. I have set of OAuth authentication details based on brands and I am looking for a way to reuse a connected system and Integration to work for all the brands. But we don't have a option to set Client ID and Secret Key in connected system via Expression rules.  Do we have any way to achieve this other than creating different Connected system based on brands?

Hi I'm not able to deploy the  SQL to Excel Plugin as its not shown when searched in add plugin on Appian cloud environment. What might be the reason?

hello community, I wanted to know if anyone has been able to establish a connection to the cloud database from power BI to use the data stored by an application in use and generate reports. I want to know if it is possible to achieve a connection either by SQL or Power BI to the Appian cloud database and see the stored data

What is the possible way of Java integration in Appian? Can we only connect Java application with Appian? Is there any other way? If not, how can we do?

Hi Team, We have a requirement where we need to upload larger files to share point. But using sharepoint connected system getting the below exception which says files of size > 266 MB  Could you provide options of implementing this use case taking scalability and performance into consideration. Thanks and in advance.

Hi Team, Does anyone has recipes for the following use cases: - Updating an existing file in Sharepoint (basically I want to create a new version for an existing file). - Upload large files to Sharepoint If you have something can you please share your ideas / developed recipes for the above? Thank you so much,

Hi ,I would  like to know why i'snt more available this plugin? it is marked as "Archived" on Appmarket. one month ago i have downloaded and  tested it and it was working as well...is there some other same plugin that i can use?BR//A.Milani

Hello, we have an issue with one of the plugin called Content Tools (https://community.appian.com/b/appmarket/posts/content-tools). We use a function "getdownloadersfromgroup" in an expression rule to find who downloaded the file. We did not have a problem with this function until now. Whoever wants to execute this expression (besides designers) gets this error: Error Evaluating UI Expression Expression evaluation error [evaluation ID = 99b65:7ceed] in rule 'hrzn_checkdownloadvalidation' (called by rules 'hrzn_s_coverletterac' > 'hrzn_f_authoritycorrespondencev2') at function a!forEach [line 4]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'getdownloadersfromgroup' [line 6]: The user [...] does not have sufficient privileges to perform the requested action. Even if we set security of this expression "hrzn_checkdownloadvalidation" to All users -> Administrator, they still get the er

Can you please explain how i can export the data from excel to database? There is no documentation or step by step process which i can follow. A simple example with few rows of data and a table will suffice.

There's a clear explanation in Appian documentation that we can authenticate web api access in Appian through 3 ways - Basic, API Key and OAuth. But, I still have some unclarity in two of them. Would really appreciate your help. Basic Authentication - Need complete details on this type of authentication. How can we configure it in Appian. I know the way how web API can be consumed using these credentials but not configuration settings in Appian. Please clarify. API Key - What is the real use of creating a Service Account in generating API key. How service account is connected to a web API and third party which is calling web API. How the actual flow and security settings work using this authentication when third party system submits the API call? Also, is Basic Authentication in Appian enabled by default. Can I disable it if I don't want to follow this method, can we have basic and API key authentication both in Appian configurations but use one of them? Thanks

Hii i am new to Appian, I am trying to implement an Appian Web API (POST method) which would be exposed to 3rd party external system. This API would capture some data points along with document as part of single POST API request body. (Document can be pdf,doc,img) and insert same in Appian DB and document folder. Currently I am able to put values in DB and using a separate implementation store document in file storage successfully. But while storing document unable to get document id on storage success which could be further mapped as reference point in DB. -- How can i get document id in workflow and store same in DB? Major documentation talks about this implementation from forms perspective but i couldn't find details to achieve same over Appian REST web API. What is the best practice for implementation and Please share any relevant documentation or sample code reference.

I have a setup where a particular column of a table contains a JSON object that I need to search through. I basically want to go through each row in that table and use JSONpath to filter out results, but I am unsure how to apply that to an appian query of the data. I figure I use JSONpath as an expression in a filter, something like the image below, but I don't know what I would enter for the required 'value' parameter. Is there something like fv!item which is used in foreach loops, but used in query filters that I can use here? Otherwise, if I am going about this all wrong, can someone explain how to use jsonpath within an appian query so I don't have to do something like query everything and filter it afterwards with JSONpath? 

Hi all, I have installed the GIS plugin [https://community.appian.com/b/appmarket/posts/arcgis-map-integration] into my DEV appian environment.  I am now trying to wire it up to our GIS system.  However, there is very little [as in zero] guidance on what the properties fields are supposed to contain.  I have tried putting the URL of our GIS system into the Map data property of the plugin [after putting the ArcGIS Map component onto an interface, however it doesn't accept a URL.  There is no documentation or examples that I could find that describe how I am supposed to wire this component up... can anyone suggest what I need to do to link this component to our GIS system? thanks heaps, David :-)

I'm trying to get from ad SFTP repo a file when i click on a startprocesslink i'm able to retrive date from the repo. but i want to directly download file on desktop client machine of the user onSuccess of the process.

Hi All, I'm getting below error when using Advanced Call Web Service (Endpoint). bundleName for SmartServiceException, builder.smartServiceClass=class com.appiancorp.ps.plugin.wss.smartservice.deprecated.AbstractCallSOAPWebServiceV2 I'm using this to convert document into base64 and send it in the soapbody xml for the webservice. Thanks Malavika

Getting below error when i am trying to authorize .Is there any resolution? OAuthResultMessage Authorization unsuccessful. We received the following error: error: request_error error_description: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

Hi Team, I wanted to compress appian documents which are uploaded by user, so i can zip them and send to other system via exposing an api , Can we  have any plugin for this? Thanks,

i Wanted to store appian document into blob format in database, Can we  have plugin for this

When using the SFTP Smart Services plugin, is it possible somehow to get the date that a target file was last modified? I would like to check to see if the file I'm about to download is the most recent version or not.

Hello everyone. I'm trying to configure an Integration with Content_Type "application/x-www-form-urlencoded" but I don't know how to configure the input parameters, and I tried a thousand ways and I can't, can someone help me? Any example....cURL (Postman)curl --location --request POST 'myService.corp/.../token' \--header 'Content-Type: application/x-www-form-urlencoded' \--data-urlencode 'scope=customer-profile-oa2p_1.0.0 card-contract-oa2p_1.0.0 demand-deposit-account-oa2p_2.0.0 deposit-account-oa2p_2.0.0 current-account-transactions-oa2p_2.0.0 credit-card-statements-oa2p_2.0.0 card-oa2p_1.0.0 credit-card-statements-oa2p_2.0.0 card-transactions-oa2p_1.0.0 current-account-transactions-oa2p_2.0.0' \--data-urlencode 'grant_type=client_credentials' \--data-urlencode 'client_id=OreHn9wPTYoHG45gNS7EgH-p5MLGBIp9LDDGrL5JLAs' \--data-urlencode 'client_secret=jE_lYqmYjyFCOpebCcZkGW0o0tS318S73bojDgsVoMU'

Hi,  I need to encrypt text with an asymmetric algorithm.  I hope to use "Java Cryptography Architecture (JCA) Tools" because it exposes many algorithms to use, and I want to use RSA/ECB/PKCS1Padding.  I don't see any method to generate Public/private key and every key I passed to keyencrypt I obtain an error:   "Expression evaluation error at function 'keyencrypt' [line 5]: An error occurred: java.security.InvalidKeyException: unknown key type passed to RSA"  This is "my code" (the key it's a generated public key):  keyencrypt( cleartext :"cleartext", key: text2hex("MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA4IJZLsjlx+o4RSvafaAcReoNnzrI0UXu7kZyXPe31ql32X9AvhC6QQIUmLkr1Evm0zP/SgVG9YX3DSqBUgPo04iv1I1/wNKwAf1/uH9EiiqdpczefyxxnzJiKUTcx2/4mA4E4QxCIL5JsZb78WoYZrd2kToW/WD01MnSFiCgSyjGdd812GY2EVzfvlv8kYuti3icMUyitEfHhtw8cAWI6/nVrRPNs0e5NsvtZJ0nfrXsfQDR0C7+ivQK+fQabi8oRGsbTZceAvVlqVE669zoIwIFLcB+eY

Any information on how to connect a pager to an appian is useful.

Hello, We are using MS Graph Email Poller for our project, and we upgraded to the latest version 3.1.0. Based on the documentation we followed all the instruction but we are getting as ErrorMessage: "Error executing the request" nothing else, could you share any insight what can cause this? Thanks, Suhas