Extensibility

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?

Hi All, I am trying to upload appian file to CMIS. I'm using CmiCopyDocumentFromAppian as AppianDocs suggests. =load( local!appianDocument, local!cmisFolderId, local!cmiCopyDocumentFromAppianWriter: bind( null, a!cmiCopyDocumentFromAppian( scsExternalSystemKey: cons!CMIS_SCS_KEY, usePerUserCredentials: true, atomPubUrl: cons!CMIS_URL, repositoryId: cons!CMIS_REPO_ID, objectId: local!cmisFolderId, properties: {name: "Example Document"}, appianDocument: _ ) ), { a!textField( label: "Folder Id", instructions: "The object id of the CMIS folder into which the Appian document will be copied", value: local!cmisFolderId, saveInto: local!cmisFolderId ), a!pickerFieldDocuments( label: "Select an Appian Document", instructions: "The selected document will be copied to the target CMIS site", maxSelections: 1, value: local!appianDocument, saveInto: local!appianDocument ), a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Copy Documen

I am trying to update particular values of a CDT from one process model to another active instance process model using Set External PVs plugin. When I try to give the same CDT type, it is showing the following error - "Invalid Cast: Cannot cast from type 'Text' to type 'CDT name' (Data Inputs)". I tried giving text datatype that didnt work as expected. It is working fine for primitive data types but not for CDT. Can anyone please let me know how to do that?Thanks in advance

I an looking for work around of calworkminutesplugin function this function used to calculate time in min so i tried with calworkhours for that but this function giving me wrong output eben for hour .

We're trying to implement an eTag to reduce query time to a remote API.  They've provided support on their end and are generating an ETag,  a subsequent GET by us, with an ETag header doesn't seem to generate the response I'd hoped, and  before I go back to the vendor, I wondered if there was something tricky in the way the quotes need to be created around the ETag string?

Hi friends I have to Integrate payment gateway for Ecommerce Application how I can do that? how we will get Payment gateway

I have been trying to configure the Send File over FTP smart service all day and have not had any success.  Not sure what else to try. Current Process Model is simply create a CSV file and upload it over FTP: Send File Over FTP configuration: External System key - avalon Use Per User Credentials - False Server Hostname  ="avalon.lhtech.com" Server Port - 21 Remote directory path  ="/Vendor_Shipment_Reports/432.csv" Document to Send - =pv!HydacShipFinal - created in previous step as 432.csv Enter Local Active Mode - False Binary File Type - True I have created my credentials in " Third Party Credentials" as avalon: Every time I run the process, I get the following error via the log: 2022-11-01 19:11:32,441 [Appian Work Item - 4585 - WorkID 114 - execution02 - process 536871728 - model 684 : UnattendedJavaActivityRequest] ERROR com.appian.ps.plugins.sftpsmartservices.FTPConfig - Login failed 2022-11-01 19:11:32,442 [Appian Work Item - 45

Hello Everyone, I have a requirement where I need to get the Precise Location details based on Latitude and Longitude. But when I am using Google Maps Plugin and using the Operation "Get Geocoding Information", It is returning a list of locations i.e list of dictionaries with location names. The resultant locations are not accurate. Is there any possible way or plugin that has other parameters such as Horizontal accuracy and Vertical accuracy. Here I am capturing the location details from Process Model "Capture location on submission". Where I get 5 Values 1. Latitude 2. Longitude 3. Horizontal Accuracy 4. Vertical Accuracy 5. Altitude Here's an example of the Outputs/results that I am getting based on my Latitude and Longitude values. Would love to have any kind of suggestion and also alternate possible ways to achieve this. Thanks in advance.

hi iam using richTextFieldWithTables component where i cant add validations that i have enterd 6 charectes name and clicked on enter it is showing count of 11  but i need to writea condintion if a user enters 4000 charectrs he should not procede further how can we give validation bcz on chage of size of text or on click on enter or by adding tables charcters count is getting count i had used strip html fucntion but it dosent help me any suggestions please 

After upgrading to the latest version PDF Tools 2.4.1, the generated PDF is having format font issues. I created a new word template from scratch which it uses the word template to convert to PDF and still no luck. I have attached screenshots of the pdf and snippet of the process model. Anyone faced this issue? Please give me your suggestions on how to solve this issue.