Extensibility

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 ?

We are facing issues with PDF from Single DOCX plugin when generating a PDF doc form DOCX. This plugin is working whit out any issues until 21.2 Version. We recently upgraded one environment to Appian latest version 21.3. After this upgrade the PDF from Single DOCX (with Fonts) smart service is breaking when generating  document. The same DOCX document we will be able to convert in other environments(21.2). We are not sure what is the root cause. Could any one know the root cause for this issue. The following is the log error from the tomcat-stdOut.log Fri Sep 10 17:03:08 GMT 2021 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disa

We are exploring calling Appian as a Client API from a custom component (docs.appian.com/.../reference-js-api.html, and I'm looking into ways to get a user's service context in order to exectue some backend services (i.e. ContentService). I could probably make some calls via Integrations/Web APIs instead, but I'm trying to work with document manipulation, so everything needs to happen server-side and it seems clunky to have my ClientAPI call an Appian WebAPI vs use public API calls. I see few other components out there are executing ServiceContextFactory.getServiceContext(username)**; but when I've tried to replicate that, but my component is returning a 500 error and this exception: --- "com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. java.lang.VerifyError: Bad return type Exception Details: Location: com/appiancorp/s

Hi Everyone, I have created connected system with Client Credentials Grant and successfully authorized but when I configured connected system to integration, getting success but body display html format. Can anyone suggest to how to get token. My scenario : I will get token from connected system and then I need to pass that token to remaining API's as Headers.  Regards, Devi.

Hello. In my particular use case. I need to integrate Appian to Azure. Mainly because I want Azure to conduct a query for me. The reason for this is that I am dealing with a database type that is not supported by Appian so I need to find a workaround. The workaround is to pass the query from appian to azure, make Azure execute the query and retrieve the required data from the database, and pass the results back to Appian.  I am fairly new to both Appian and Azure.  Can anyone here give me a rough guideline as to where to start? 

Hi All, I am doing third party integration and need to retrieve PDF document. i am doing in below way.  Document get stored in target folder but when i open this document, this give below message. I thought to store this document in process variable by using Integration smart service. please find below. i got following below error. Kindly help me. Thank in advance.

Hi, Could someone please me resolve this issue? We are facing severe issue in the application. Because of this we are not able to upload the files to the an outside system. execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.plugin.wss.smartservice.AbstractCallSOAPWebService - Error invoking web service com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 401: UnauthorizedThanksFaisal

hi, i want to overwrite/update the existing appian users email address in our environment.  i loaded the users into pv from csv document. want to iterate this user update in the process model. i am looking for update user profile smartservice. but am unable to find the plugin in community. can anyone help me here?

Hello team,  I was wondering if receiving files from SFTP can fetch files by batch or just one file at a time. Also, can we specify what files to be fetched only based on the file date when it was uploaded to the server? Thank you.

Hi  I have integration with post method, I'm getting success response with token in body  but I need to call this integration in Expression rule and fetch the token field and pass that token into remaining API's.  ->I have tried to call in expression rule but getting output as "Smart Service". How to call the post method integration in expression rule. can anyone suggest on this issue. Regards, Devi.

Hi Everyone, I have integration object  with basic authentication with user name and password so I need to encrypt the password in integration. How to do the encrypt the password in integration. can any one suggest on this. Regards Devi. 

Hi All, OKTA is not able to verify APPIAN using event Hooks?  we have create get and post api in Appian ,but still its not able to connect . I think missing very small part. Did any one connected earlier then please help

Hi community, Can somebody explain me the difference between body parsing to Appian value and the use of a!fromJson to convert the whole response body to Appian values? Kind Regards, Erik

Hello everyone. I was advised that I need to start creating a process to fetch file from SFTP and retrieve date from the fetched file. However, they are still discussing with another team to provide us the details for the server to be used so I was wondering if I can use my own computer as file source or any free 3rd party that I can use to start developing. If there is can you kindly discuss what are the details that I need to set it up.  Any help will be highly appreciated.  Thank you.

when I check for the Authorization on the Connected System I click on Authorized Again (Where I am assuming I get the Token) how can I automated this procedure ?

readexcelsheetpaging( excelDocument:cons!BOOK_4, pagingInfo:a!pagingInfo(1,-1), sheetNumber:0, numberOfColumns:4 )