Extensibility

Hi, As per my requirement I had to make use of the plug-in called "Twilio" for sending SMS to the users to authenticate them. I also created an account in Console Twilio in order to get the tokens to establish the connection. And I managed to get the URLs of first 4 fields like the Account SID, Authentication Token, API Key SID, API Key Secret.  But I am unable to get the path for the remaining 3 fields which are TwiML App SID, Workspace SID, Chat Service SID. Can anyone help me out how to configure the remaining and from where can I get the URLs of those particular fields. Thanks in advance, Gousi.

Hello everyone, I'm just starting learning to work with Appian, I'm currently doing the Developer's Path. Today I encountered a problem that seems very simple. I just can't add Rule Inputs while creating a connection to an API I tried clicking in edit as an expression, but I'm just getting this Thanls

Hello, I've been trying to make a dual-y chart. If I understood correctly, I had to use googleScatterChartField, but I can't see the labels of axis and values for the second y. The code is here: a!localVariables( local!colData: {{ type: "number",id: "Age",rowDataKey: "Age"}, {type: "number",id: "Weight",rowDataKey: "Weight"}, { type: "number", id: "Height", rowDataKey: "Height"}}, local!rowData: {{Age: 28, Weight: 43, Height: 10}, {Age: 9, Weight: 39, Height: 20}, {Age: 2, Weight: 52, Height: 30}, {Age: 20, Weight: 72, Height: 35}}, { googleScatterChartField( label: "Chart", validations:"val", chartColumnData: local!colData, chartRowData: local!rowData ) } )

Hi all, Is there any way of integrating Appian with a IBM Informix database?

I am creating an application that shows an alert to users to authorize an Connected System so that an integration can work. now I want it to be shown to user only when they have already not authorized Connected System so ,how can I check if user has already authorized for a connected...??

Hello, I'm looking for automation to validate that all plugins installed in our QA environment are also installed in our production environment. Right now we have to read through the list of plugins in our admin console but this is a manual process that we're looking to get away from. Does Appian provide a web api or anything that would allow us to get a list of plugins for each environment?

Hi Team, We have a requirement where the client tool can only upload files which are in octet format. We have exposed a web api using "upload document" template of web-api which helps client team to upload files from their systems to our Appian environment.  Can someone help me with the code required for uploading a file in octet format from external system to our appian environment using a web api. We use appian version 22.2 Thank you

Hello! I would like to send JSON payload to external API after the user completes ADD NEW CLIENT form created in Appian.  { "lastName": "John", "firstName": "Smith", "birthDate": "1987-04-26", "emailAddress": "shogun@go.com", "mobilePhone": "+60-11-12345678" } So the information provided in this form would be sent externally. I created connected system HTTP and POST integration. I suppose I need to also create a CALL INTEGRATION smart service that would send this payload externally, after adding newly created client to Appian Data Store. Am I correct? Am I right?  I don't know how to capture in the integration itself the data from a given smart service in a process. So basically now what happens is when I complete the add new client form it triggers the call integration smart service at it sends to external API hardcoded JSON data from below. Do I need to call these process variables from JSON? Am I going in the right direction or am I entirely wrong?&n

Hi,  I am getting below response from Integration & I want highlighted part only in output. how we can achieve that? Regards, Kiran

Hello, I am using Google Gantt chart for my current project for display dependency task data like Task Name, Start Date & Time, Due Date & Time and Duration. Here I want to display Day (Sunday, Monday, Tuesday .....Saturday) instead of date can any one help me to how to we achieve this for this Plug-in. I have tried these Appian Date to Day Convert Functions (text and weekday) but when write the format like "dddd". the plug-in throughs an error as below. Thanks in Advance, Mahesh

I have a WEB API that starts a process with a start form and writes data to the record using the 'Write Records' smart service. When i test the WEB API, I get the following error. The Write Record configuration looks like this.

I am trying to upload an excel file to my application and then use this file as a data source for Tableau Dashboard. Problem I am facing here is that Tableau cannot access the file which I have uploaded on Appian folders. I am open to all kinds of suggestions for this, I just need to use the data from this uploaded excel file in Tableau as the datasource. further I will be displaying this Tableau Dashboard in my Interface using Web Content Component.

Hi, We have installed SAP JCo (Java Connector) on Appian Cloud Server, to call SAP BAPI using Sap Invoke functions provided by Appian. We are consistently facing cache issues in our environment where the BAPI configurations and credentials used with SapInvoke function does not get refreshed. Due to which we are not able to fetch updated data in proper structure. This generally happens when an existing BAPI configuration gets changed or modified at SAP end. As per our understanding of SAP JCo, it caches metadata to improve the throughput of the application. However, please note that if any changes are made to the BAPI structure in SAP, the old version will still be cached until the cache is refreshed via a server restart. We were able to find a Knowledge Base Article - KB1232 to clear the cache, but our understanding is that it is targeted for on-premise servers. I would like to know if there any other effective method that we can take to handle this cache issue, other th

i developed a smart service in appian  iam facing a issue while adding external jars getting classNotFoundException while using the plugin in appian even i simply copy paste the required external jars in META-INF/lib folder after convert into jar and deploying the jar in onpremise server while running the plugin classNotFoundException we got for creating a WorkBook 2023-02-09 13:08:47,874 [ThreadPoolTaskExecutor-9383] ERROR com.appiancorp.process.workpoller.WorkItemListener - The following exception occurred while attempting to complete work item [[WorkId: 45, EngineId: execution00, Request: UnattendedJavaActivityRequest:1154462 as M0223 by M0223, ProcessId: 14617, ProcessModelId: 726, Response: null]] - Exception: javax.resource.spi.work.WorkCompletedException: java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTWorkbook at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:247) at java.util

Hi, My data resides in Neo4j graph database. I need to connect to Appian and build a relational DB based on this graph data model. Is there a direct connectivity possible to achieve this? I'm looking for a direct integration from neo4j to Appian in the form of connectors or ETL tool or API's. Please let me know. Any help appreciated. Thanks, Sonia

Hi Everyone, I am trying to connect to sqlserver as a new data source from admin console  and providing the connection url , username and password as provided by the client. Additionally trying to create the connected system with the same credentials but both the time I am getting Test Failed. Please suggest if am missing something. Thank You!

I want to make an application that uses Import CSV to Database and updates CSV files from an interface.What steps should be taken to create it?Are there any other required objects besides interfaces, process modellers, and CDTs?And what settings are required for each object?

Tell me how to use the plugin “Import CSV to Database”.I downloaded the plugin but don't know what to do next.

Is it possible to connect Appian On-premise with Teradata using jdbc?

I have an integration requirement where the system to which I want to connect Appian with needs an Authorization Header which is in the format as: Signature keyId="<8>-<4>-<4>-<4>-<12>",algorithm="hmac-sha256",headers="(request-target) host date",signature=”**” Has anyone done this kind of integration? Note: The swagger provided doesnt have any authentication details in it.

Hi, everyone I would like to integrate Appain'DB to MS Access'DB.In order to do it, I am tyring to create RPA Robot that excutes JDBC to read or write to Access'DB by costum Java code. If you have better idea or know how to create RPA Robot that excutes JDBC to read or write to Access'DB, could you tell me about it? Thank you.

Hi, I want to send sms to mobile number for authentication. Can anyone know best possible way?

Hi, everyone! I need to import a spreadsheet data into a database table and I'm using Import Excel to Database smart service for that matter with parameters described below: Batch Size = 1000; Data Source Name = "jdbc/Appian"; Database Field Names = {  "EQUIPMENT_NO",  "MATERIAL_TOT",  "SUPERIOR_EQUIPMENT_NO",  "SUPERIOR_TECH_ID",  "CALCULATED_ACTIVITY",  "NEXT_LEAK_TEST_DATE",  "HAL_SERIAL_NO",  "ISOTOPE",  "SORT_FIELD",  "AMI_DOCUMENT_NO"}; Excel Document = pv!sapInventory; Excel Header Names = {  "Equipment",  "Material/TOT",  "Superord. Equipment",  "Superior TechID",  "Calculated Activity",  "Next Leak Test Required Date",  "Halliburton Serial No.",  "Isotope",  "Sort field&qu

Hi, In my application I am sending emails with task/record links. The user can click on the link and the link takes him to the task/record or Appian login page, based on whether the user is logged in. I got a new requirement to count the number of clicks from email to Appian, without using any other technology outside Appian. For this, I came up with two Web API endpoints, first GET with link to itself in the email sent. GET returns HTML website with automatic POST page that utilizes second WebAPI, which runs a counting smart service and returns the original task/record link. This solution works only if user is already logged in into Appian, otherwise an ugly error is returned to the user, see below. My question is, is there some way to force the Appian Log in page in case no valid session is found when trying to use the GET API and then redirect him back to it - with the GET API being linked from an email. Thanks  error:  "error":"APNX-1-4187-000&qu

I have a requirement to access the database in Appian Community Edition from the Appian Cloud Edition. Can you list out the steps that I need to follow for this?