Extensibility

Hi We have a scenario where we have to Post a comment  json at every step in our work flow. calls count will be very high,When I generate a Health check which is in High risk which is taking 25.2% of all CPU time, 22.9% of all operations, 8332 mins of CPU time, 108948293 operation count. we are not doing any other operations in that PM just call integration. Any suggestions to minimize this CPU time or how to improve performance? 

Hi Community, i am stuck at an issue, that i need to configure the SFTP Retrieve Files In folder node. How we can setup File Transfer Configuration property of this node. Kindly, help me out for this configuration.

Hi,  I have a excel sheet in which the Excel sheet headers start from different row (example: row-8). In a process model, how can I read it from row 8 using Import excel to database smart service.

There is an app in appmarket called marketplace which is free. So,how to deploy it in my community environment?

Hi I'm using import excel to database plugin to export data from excel sheet into database. I'm not facing any issue in the process model and data is not saved into database. Then I dig in the logs and found out below error.  Could you please let me know, how to resolve this issue.  Caused by: javax.naming.NameNotFoundException: Name [[Data Store Entity:"1460e773-36a5-4c3a-afad-04711683a7cd@5528"]] is not bound in this Context. Unable to find [[Data Store Entity:"1460e773-36a5-4c3a-afad-04711683a7cd@5528"]].

In Advanced rich text editor, i want to save a image, then how to save the source code of that image which is view in menu bar into a variable?  I want to save below source code into a variable:  But, When I pass a variable in richTextSaveInto, it save like below:  (length of characters: 247454) which is too long to save into DB. So, I want to save the source code which is view in menu bar  Please anyone suggest !!

I got one point in docs, i.e  Using the Write Records web API template, define an API that lets you create more than one Employee with a single request. link is - Web API Tutorial - Level II - Appian 23.3 so, please anybody help me on that, how to create or implement that? Thanks in advance.

Does anyone know if there's a maximum document size restriction for the Send File Over SFTP smart service?

Hi All, Getting an integration error :  AppianRPA returned a KO invocation result. we have double checked the below for troubleshooting but still error persists : User has no permission to view or access the robotic process The executionId is invalid or missing The executionId is not in the correct format An invalid API key was used to make the request please help !! 

I want to create a Google Drive Connected System, but i don't know from where I will get the Client ID and Client Secret, Can anyone please help me out.

Hello Appian community,   There is a way to create an EML file other than using the plugin "Create & Read Email Files Utilities"?   In this moment y have 22.4.870.0 version  Thanks in advance  

Hi team, Am working on an app which aims to updated external database(Mongo DB) and for this we are using Mongo DB connected system. Now we have a use case where we must update an existing collection entry with new details, and we are facing problem to update it correctly. Below is my collection structure.   Col A      Col B Col C [ {NestColC1A,     NestCol C1B,      NestColC1C}, {NestColC2A,     NestCol C2B,      NestColC2C}, ] Col D [ {NestColD1A,     NestCol D1B,      NestColD1C1[ {NestNestColD1C1A1,                    NestNestColD1C1B1,                      NestNestColD1C1C1}, {NestNestColD1C1A2,          &nb

Hello Community Members, While using Export SQL to Excel Plugin, we are observing that it is over-riding existing file in same folder if file name is same instead of creating new file. Anyone observed this behavior before? Any workaround like changes in Parameter that may mitigate this. Keeping file name unique is alternative, but we have case where same file name can be present multiple times in same folder. So need to understand if it is the known plugin behavior and file name should always be unique if using this smart service "Export SQL to Excel"

Hello everyone, we have a new requirement to connect JDE integration I am not sure how to connect JDE from apian can anyone guide me please Thanks!

Hello, i have a Web Service and i save the Result.body response as in a process variable map. For auditing reasons i need to save this result as a *.json file that just needs to stay in the Knowledge Center for now. How can i achieve this? I have tried using a template but from Map to document i loose all the Json elements. Thank you

Hi, I need to export data from multiple data store entities into excel sheet. Current I am using "Export Data Store Entity to Excel" smart service but this services takes only one Data store Entity value as highlighted below. How can I take multiple Data Store Entity values and export to excel at once? Please advise.

Hi Community, I am trying to generate a JWT using createtokenwithsecretkey() in JWT plugin (using HS256). When I use the generated token and hit the Tableau signin API, I get signin error and JWT is invalid ( details error code: 10083). However, I use the same parameter details in a python code and use the token generated, the API returns me a successful response. Can anyone help me with the issue on Appian side please?  createtokenwithsecretkey( externalSystemKey: "jwt", /*Set the third party credentials in Admin Console */ iss: <tableau connected apps clientID>, aud: "tableau", typ: "JWT", /*jti: fn!generateuuid(123),*/ exp: 43200 )

Hello Community members, I am using the 'Get Base64 document from database' smart node to fetch a document from the database. As part of the new requirement, I need to fetch multiple such documents from db, create a ZIP file and allow users to download it - all in one click. I tried creating a web API to call an Appian integration that starts a process. The process uses either MNI or looping flow to fetch all the documents, creates a zip and terminates. Both options seem to be unreliable as not all the docs get downloaded using a loop or MNI with activity chaining (plus it's not best practice to use MNI + activity chaining). Have you encountered similar problems in your project? If so, do you have a solution for me?

I have requirement to call service now API before every manual deployment. Appian support team should not be able to deploy package in Production if change ticket from service now is not approved or not in  start time and end time window. I have achieved the integration by calling service now API but I am not able to restrict the "DEPLOY" button on Appian Production screen based on the check. Is there any way we can restrict the deployment here?

Hello, I'm currently testing the Selenium Appian API and we have this component (richTextField) from the Rich Text Editor Component plugin used to style sent emails. I cannot populate the field even though the verifyFieldIsPresent method returns true, I've tried using the populateFieldWith method and Selenium findElement directly without success. Thank you so much!

I have tried with Web Content Component it will embed page with provided source url but it will ask for logon and password again.

Hi, While getting data from DB using in WebAPI, getting Z appended only in the datetime field as below. WebAPI: a!localVariables( local!Details: rule!XXX_DetailsView( batchSize: http!request.queryParameters.batchSize, startIndex: http!request.queryParameters.startIndex ), a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson(value: local!Details) )) It's a simple GET API. NOTE: rule!XXX_DetailsView - This is queryEntity used to get data from View. Anyone can advise, what could be the reason, and how can we remove this extra 'Z'.

Hi, I am trying to integrate a web api in Appian enviornment but getting error that The connection is not secure even the web api is secured by SSL certificates.  Apart from this, I am able to access web api in postman without any errors. Please suggest me what should I do to fix this.

I am trying to set up an OpenAPI integration based on the JSON provided in the link below, but it is giving me an error message "The selected OpenAPI document could not be parsed" when I upload the document. Does anyone have insight here? I am not seeing anything in Appian's documentation that would assist troubleshooting.https://docspring.com/api-docs/v1/openapi.jsonSource: https://docspring.com/docs/api/openapi.html

Hi, i am exploring building the component plug-in for the below activities: 1. i will pass the parameter to the plug-in and based on that parameter the plug-in should get the data from the database and show it on the plug-in itself 2. if i modify the data on the plug-in it should update the same data on the database. Please suggest the approach for the above requirement. please let me know if any sample plug-ins