Extensibility

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

I've been using the "SFTP Smart Services" plugin to retrieve a csv file through a process model. What I'd like to do is download the file, read the data, then write the data to the database. Right now I am stuck on the retrieving part. The "Receive File Over SFTP" node works without error (at least not any error that stops the process model) and in fact I am seeing the file appear in the document folder I sent it to. However there are some problems: 1) the file is listed as "Not in this application" (an issue I only care about if it prevents me from doing the rest of the operation, which I assume it doesn't) 2) when I look at the process details, the error output says "2: No such file" and the status says, "FAILED" 3) the document output doesn't output the file we've just retrieved.  Since the document id isn't output, I can't go further than this in the process model. Any ideas on what I am doing wrong?

i have a table of 6 fields . i am requesting the data with GET request so that i want to show only 3 fields from the table. How can i do that?

while creating in service account the API key is automatically generated but when I try calling the API service in postman it is asking key and value. Where can I get the those values.

Can we call the web API service outside the Appian without the 3 authentication services(Basic Auth, API Auth, oAuth 2.0)

how can I call postman into my appian using web api application.

HI Everyone, We have a scenario where we need to share documents with non appian users. Can someone help us how we can do that what protocol is required ?

Hello, I am using a WebService query smart service to do Get and Update Merchant. We do a Get call to get the latest data,  modify the returned object, and update using the UpdateMerchant call. Thers is an attribute "LastModifiedDate" which holds Date Time, not supposed be modified. I am just passing without any change. But there is a random 3 milliseconds difference during the Get and Update. I am seeing random success response but its intermittent. Becasue of this difference, the Update call is throwing an error with "Unable to add due to typical Microsoft CRUD design - Status - OutOfDate.. I am not sure how Appian gets the raw data. I could only see data once it is converted into an Object. Did anyone face this issue or what could explain the error? Thanks