Extensibility

Hi,  i am trying to send data to Data base using Web API POST method. but, i am receiving below error. below screen shot, that refers to giving data in JSON format. could you please explain why i am getting that error message.

Hi, I tried to call web API Get method from Postman . It returns result and working fine. But when i try to call from appian . it throws error. errorIntegrationError title"The external system encountered an error"(Text) message"Failed to connect to https://api.XXX detail"HTTP/1.1 500 Internal Server Error"(Text) What could be the issue? Thanks, Dharsana.G

Hi, I have created a!writeToDataStore in webAPI which is writing to DB when I test through API,to invoke this API I created an integration of Method POST and URL accepting ri! as parameters. I am unable to write to DB when I test through integration.Can someone please help where I am going wrong. Later I want to use this integration in my interface. Thanks in advance!

I have created a WebAPI - Write to Database - POST When I send an array of data, it only takes the first dataset. How to process all the records in the array? a!localVariables( local!value: cast( 'type!{urn:com:appian:types:YM}XX_WebAPI', a!fromJson(http!request.body) ), a!writeToDataStoreEntity( dataStoreEntity: cons!XX_WEBAPI_TC, valueToStore: local!value, onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( fv!storedValues ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( { error: "There was an error writing to the data store" } ) ) )) Sample Data Set: [ { "Column1": "AA",   "Column2": 1111 }, { "Column1": "BB",   "Column2": 2222 }, { "Column1": "CC",   "Column2": 3333 } ] Thanks

Hello, I am confused as to how we can populate the body of a POST http call? I have an API that will receive a post request with data in the body. I want this data to be dynamically created in Appian.  I would appreciate the help. 

Hello people!  I am trying to find a way to connect data from a BigQuery table I have, I found a potential way to do it: By using its API.  I was able to connect correctly, using a service account , when I then create the integration and I test the connection, I do get the response with  kind"bigquery#tableDataList"(Text) etag"sU8HN6M/RRhXMIrmq4pJgfrw=="(Text) totalRows "5444"  (And I also get this ) rowsList of Dictionary - 5,444 items So, as you see the response brings the rows on it, but then when I go to the data source, it does not show me the rows, only kind, etag and totalrows columns, any idea on how to create the table based on the response I get?

Has anyone come across the following error while opening a .docx file generated via ADT (DOCX Document From Template): Unspecified error Location: Part: /word/footer4.xml, line:0, column: 0 This error is only introduced after the doc is generated using ADT. The template being used works fine when opened using word.

Hi, We have succesfully created an integration with sharepoint as described in this link  https://docs.appian.com/suite/help/21.2/sharepoint-connected-system.html We would like to implement the DELETE operation of a document during the process inside a sharepoint folder. How can we accoplish that? all the listed operations doesn't allow it

We  have a 2 environment with same IdP (ADFS)  our certificate was expiring hence a new PEM cert was loaded into Appian on TEST the SAML Authentication works but the same does not work on DEV. They both have identical configuration and metadata files from IdP. While looking at the tomcat logs on the environment that has issues i see following SAML errors in the logs. 2021-09-29 18:50:29,928 [ajp-nio-0.0.0.0-8009-exec-202] ERROR org.opensaml.xmlsec.encryption.support.Decrypter - Failed to decrypt EncryptedData using either EncryptedData KeyInfoCredentialResolver or EncryptedKeyResolver + EncryptedKey KeyInfoCredentialResolver 2021-09-29 18:50:29,929 [ajp-nio-0.0.0.0-8009-exec-202] ERROR org.opensaml.saml.saml2.encryption.Decrypter - SAML Decrypter encountered an error decrypting element contentorg.opensaml.xmlsec.encryption.support.DecryptionException: Failed to decrypt EncryptedData        at org.opensaml.xmlsec.encryption.support.Decrypter.

Hello, We have configured SFTP Functions plugin and using the smart service "Receive Files in Folder Over FTP". Though this has worked how it has to at first, now we were not able to retrieve files from FTP and the error we see is " Name or Service not known ". Don't know if this is something related to network side credential change/ some change in the plug-in itself. Please let me know if there are any leads on this! TIA Jahnavi

Hello, Usually connected system for http type accepts only http/https url  do we have anyway to connect using URL starts with wss (web socket connections)

Hi All, I have a requirement where i need to pass two different images over different location in docx dynamic template. «[#list logo as logo]» image«[/#list]»   location 1 . «[#list lang as lang]» image«[/#list]»  location 2. As there are two images to be added , i am passing ={logo:pv!photo,lang:pv!photo} to the Image input parameter of the smart service. But only the logo paired image is getting displayed and the other one doesn't show up. So can anyone help me in the syntax or the annotations needed to get these images rendered?

Hi, I am developing a function plugin for appian. I am following the steps in this page https://docs.appian.com/suite/help/20.2/Custom_Function_Plug-ins.html am confused about one thing. Where do I actually include the java files for my plugin? I am inclined to put them under the functionPlugin package, but the documentation is confusing.  This is my current path. I have appian SDK and google 3rd party library under referenced libraries. Is it fine to include 3rd party libraries, and did I locate them in the right folder? The reason I am confused if I included the dependencies in the right folder is that in the url above. it is mentioned in step 14 to "Add any JAR files required by your custom function to the src/META-INF/lib/ folder." Technically my function depends on the ORTools library, but can't i just use it as a referenced library?  this is what they recommend on the website.  do the dots in  "com.example.plugins.<YOUR_

Hi, My use case is the following. I need to automatically assign new daily batch of tasks to workers. Each task, worker has a set of skills. The task's skills must match the worker's.  Additionally, the algorithm must assign/distribute tasks as equally as possible.  I have come up with a way to do this by reducing this to a graph/flow problem. Problem is, it is super hard/impossible to implement this in an expression rule. As such, I want to develop a custom function in appian in Java.  Which way is better to this, via Servlet or custom plugin?  Thank you,

Hello everybody,in one cloud of ours (running Appian 21.2) we are facing this issue.We have uploaded the plugin: "Text File Utilities 2.0.0" in order to use the readtextfromfile() function.When we type the name of the function readtextfromfile in a rule, the name of functionis suggested by Appian, but when we execute the function, the following message appears:"Expression evaluation error at function 'readtextfromfile': The function 'readtextfromfile' is unavailable."I also looked at in the tomcat-Stdout.log of today but I did not find nothing related to this plugin nor to the function. Last, this problem does not arise in my personal Community Edition.Could you please give me some advice or suggestion? Any help is greatly appreciated, thank you in advance.Best regards,Paolo

Hi  I am using SharePoint Connected system for my integration to Download a File and seems it is not working. The integration rule returns SUCESS for "List Folder Contents" operation having a single document, however results under File shows 0 items (when there is one document available) While downloading the file I am getting following error:

Hi Every One, I have one integration with OAuth and token generated in header so how to fetch token from integration header. I have tried like  rule!Ma_integrationobjectname().result.header.token             but getting null value. Can anyone suggest on this.  Regards, Devi

Good morning, We are doing an integration where one of the "ri" we are using is a text type. The problem we have is that the size of that text exceeds 4000 characters and the integration does not work, is there any way to enlarge that size. Thank you very much

Hello everyone. Is it possible for me to set the Source Document in Send File Over SFTP in my Appian folder and find the files based on the file name list provided by a process variable. Any help will be highly appreciated. Thank you.

Hello,My team and I are trying to use a jar but without creating a plugin for Appian. Any idea how to use a .jar in a process model?

Hello. We are having a very unusual problem with the Reconcile Doc Extraction Smart Service node in our process models. Everyone in our team can run the process model, start the document extraction and run the reconcile node without issues, except for a specific user. The error is the following: An unexpected error occurred while displaying the PDF for the run. We tried the following methods/verifications in order to debug the problem: The user is a System Administrator; The user belongs to the same groups that the other users belong to; The user has Admin privileges to the document used; We tried multiple process models in order to try to isolate the problem, but the issue persist even if we use a "sandbox" process model. For the users who run without issues, the process is the following: For this particular user, the process fails on the reconciliation node: Whenever the user tries to "View Form" on the reconciliation node, the user gets immediately the error

Hello everyone, I attempted to use Send File Over SFTP and set a folder but I am getting an error below. Is it really possible to send a folder will multiple files inside using Send File Over SFTP? If yes, may I ask for guidance how to do this? Or any solution how can I send multiple files to SFTP because the way I see it we can only send one file at a time. Any help will be highly appreciated. Thank you.

Hello everyone, I am working with an SQL developer and he created a stored procedure where each time a I saved a record in his staging table, I need to execute his stored procedure to transfer the records to our main table. I am just not exactly sure how I will add it in my process model.  I am adding records to his staging table through process model too by using Import CSV to Database v6. Next step should be calling his stored procedure to transfer the records to main table. Any help will be highly appreciated. Thank you.

Interested if anyone has investigated connected system plugin for Google BigQuery (DB Connection via JDBC)?  Any information will be useful 

Team, Any solution for below ? We are calling Appian environment API from another Appian environment using integration. Way we access destination system out side of network , first we will be taken to multi layer authentication and based on correct username password and mobile token we will be ale to access appian URL. Not how to call API from source because when i am passing API URL it is saying success but going to multi layer authentication , how to bypass it ?