Extensibility

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.

Hi While using Import CSV to database, i am facing this issue, Error message : Error executing SQL.Can any one help me with the solutionThanks in Advance

Hi I want to test an integration which should create a new record in an external system. This is the code that creates a 'job', with its name, the department, an array for the offices ids and a template_job ida!tojson({ "job_name": "AppianFlow3"& " "&"Related data"&ri!record['recordType!NJW NewJoiner.relationships.njwGhOfficePicklist.fields.officegh']&ri!record['recordType!{1fc618ce-6255-402a-81f8-007ca9ca5de4}NJW NewJoiner.relationships.{925eac6a-be91-4fe5-b4a3-1009d480994a}njwGhOfficePicklist.fields.id']& "NJWRecordType"&ri!record['recordType!NJW NewJoiner.fields.division']&" "& ri!record['recordType!NJW NewJoiner.fields.businessmanagerapprover']&ri!record['recordType!NJW NewJoiner.fields.id'], "department_id":"4076573002", "office_ids":{"4036737002"} , "template_job_id":"5468426002" } ) I want to test the integration by getting one record by id of the record type NJWNewJoiner and parse in the json request some fields from the NJWNewJoiner Record type as well as

Hi all, I have a problem converting bolded words from docx to pdf using PDF from DOCX Smart Service. Bolded words have special characters(need to use UTF-8). Is there a way to do this using this smart service(pdf options)? Thanks in advance.

I am trying to return a document to a component plugin via a connected system plugin's clientApi.  However, I have not been able to find a secure way to retrieve the user in order to do so.  Is there a way to get the user from the session server-side?

Good Evening Great People, I keep having a problem with the Import Excel to Database Plug-in Smart Service. I import the Data, the are no errors on all the notes, however the information is not written to database. The first time, I encountered the problem, I just deleted the plug-in and re-deployed it and it worked. The second time I encountered the problem, I reverified the Entity mappings on my Datastore. Then the third time, I resolved it by removing the delete  Today, I encounter a similar problem and I have tried the previous tricks non of them work. What are the possible reasons that this plug-in could fail to write to DB even though there are no process note errors Your assistance would be highly appreciated thank you

I have created an apian web post API. api is working in appian and when i try to test it in postman its gives error 501. how can i test it in post man. need help. i already created outh credentials and also added the service user to the application groups.   a!localVariables( local!value: cast( 'type!{urn:com:appian:types:TFA}TFA_TESTING_RT', a!fromJson(http!request.body) ), a!writeToDataStoreEntity( dataStoreEntity: cons!TFA_data_store_constant, 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" } ) ) ) )

Hello Appian People, I have integration GET(Queries Data). Basically this integration search address. And I call this integration in the interface. In my interface I have a texbox and search button, whenever the search button is clicked if there is corresponding search result returned in the integration or if the integration search result is onSuccess the result value will print. So my problem is, how to check if  the result of the integration in the interface  fails/failure and gets the corresponding message of the integration error?