Extensibility

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?

How to invoke Appian WebAPI with OAuth2.0 clients from postman? And Do I need to add any query parameters as "Authorization" in Appian Web API for setting OAuth 2.0 clients?

Hi, Does anyone know of any plug-ins or perhaps connected system integration approach through external service which might support the capability to convert a Flattened PDF to a fillable PDF?   This can be done manually using Adobe editor.   Have a requirement to consume a PDF produced by external system which cannot be modified  which is flattened but need to unflatten form fields and a signature field.  Would prefer not to have to go down develop of custom plug-in approach. Regards, Bob

Is there any page in appian to see all the available plugins that are available in the market provided by Appian?

Hello, I am working on a connected systems plugin that needs to work with the data entities and storage within Appian. I would like to know whether it is possible to create data entities automatically through the plugin if they don't exist and read the data attributes (not only values) of entities all using the Java API. It is also unclear to me from the documentation where I should even begin to look when working with the Java API, so if someone could point me in the right direction as well, that would be great! Thanks!

Dear Appian Community,i want to call a pretty common webApi with a regular JSON request.Usually no issue. CDT/Map tojson() go for it.Just faced that a key is mandatory at the receiving end which has a "space" in it.But CDT field names and Map paramters are just working without space.To show what i mean:the API expects a JSON parameter like "Creation Date: "my CDT has "CreationDate" (so space missing) Any ideas to solve it?Still amazed that i never faced that so for.kind regards,Richard

Hi, I am using Create PDF smart service to generate a PDF with plain text. Am getting the following error in the Create PDF node. ???contents.error.alertMsg??? Error Text: U+000A ('controlLF') is not available in the font Helvetica, encoding: WinAnsiEncoding Am using the following expression to generate PDF contents a!localVariables( local!text: "Firstname Vikrant " & char(10) & "Lastname Bhardwaj " & char(10) & "Address 100 NW AVE " & char(10) & "City Irving " & char(10) & "Zipcode 12345 "&char(10) & "Country USA",'type!{urn:appian:ps:pdftools}PdfContent'( sections:{ 'type!{urn:appian:ps:pdftools}PdfSection'(   style:'type!{urn:appian:ps:pdftools}PdfStyle'(   font:"Times New Roman"   ), components: {  'type!{urn:appian:ps:pdftools}PdfText'(  value

Integration returns: HTTP/1.1 302 Date: Wed, 04 Jan 2023 16:05:55 GMTServer: Apache/2.4.41 (Win64) OpenSSL/1.1.1cX-Content-Type-Options: nosniffX-XSS-Protection: 1; mode=blockLocation: /MyWeb/CreateNoteContent-Length: 0Set-Cookie: MYSESSIONID=ABCXYZ123456; Path=/MyWeb; HttpOnlyVia: 1.1 myserver.dev.comKeep-Alive: timeout=5, max=100Connection: Keep-Alive I want to cal this integration via a link or a button from an appian interface.

Hi in my project there is a requirement to read the polled email data. I used the Poll Email plugin to poll the mail in to the folder. The body is polled with a .EML file extension. The body of the mail is unstructured and I need to poll the body in text format in to a table. Any suggestions??

The team is using the automated import plugin to perform database upgrades. Flyway produces logs that the team can retrieve by pressing the link on the information page that appears after the deployment. Is it possible to retrieve the logs at a later time?

Hi community, I have a PPT document, is there any way to convert it into PDF file ? Even converting to DOCS would be fine then I can convert DOCS into PDF easily. Thanks

I have a requirement wherein a table with some information in the columns and  one column with link for each data has to be sent as a PDF attachment over an email to a set of users. We see that the table data populates fine but the column with links when using the PDF from HTML smart service populates as a simple text not as a hyperlink.  The syntax we used for the link was "<td style='width:5%'><a href='" & fv!item[recordtype.url] & "' style='color: #0068a5;'>www.google.com</a></td>" When the rule is called the following data appears but the click here is a text not a hyperlink. Any help is appreciated.

what is the difference between HTTP connected system and open API connected system

I have design a smart service plugin.but during executing if I miss something in configuration,still process is not breaking.I want if plug-in fail process instance should break and error message should display in process details under errors.Please help me for same

Hi Friends, I have a Small doubt, Can we create a plugin using Appian SAIL Code ?

Hi Everyone, Send Email smart service is throwing "Failed to send email" error in the first instance. But when we restart node is working fine. can somebody tell me what the issue is here please.  Thanks in advance

what are the steps to follow in schedule a teams meet link in outlook and also how to cancel the schedule event and how to reschedule the existing schedule Meeting ? 

Hi Everyone, Is there any plugin or approach to display the Realtime notification to logged in user in Appian. Example: Use case is, whenever the case created and assigned to any logged in member, should see the desktop/web notification saying case assigned to you. In Realtime users they opened the homepage,they would like to know whenever the case is assigned to particular person through desktop/web notification, so they act immediately. Otherwise, users need to keep on refresh the home screen. We thought below two approaches but see the couple disadvantages. 1. When the case is created, can send an email to user and user can enable the outlook desktop notification feature but at this movement we would not increase the emails.  2. Add the refresh interval to get the data but it is not that much of user focus. Alway need to focus on the screen. Could you please help us is there any other approach/plugins. Thanks In Advance!!