Extensibility

Hi team , In SFDC integration , we are using SOQL query in operation to fetch some data for a given financial id , need to understand how to write the query to fetch data for multiple values involved.Current implementation - concat(Select shareclass_c from breakdown_c where financial_id= ' ''' ,ri !finId) ;How to write above for fetching data for multiple financial id's involved , ri! finId will be of multiple type of string . Tried to replace above = with IN operator in where clause, it shows malformed SQL as integration error.Thanks 

Hello Team,I am using Appian version 25.1. I need to use JWT plugin function createdocusignrsajwttoken , but I am getting below error when used in an integartion:Expression evaluation error : smartTestPane.errorInfo.inFieldBodyThe function 'createdocusignrsajwttoken' is unavailable.I have updated version of jwt plugin  Let me know if its not compatible or what could be the issue?

Hi everyone. I have a json providing by a WebService like this : [{ "id": 1, "title": "Essence Mascara Lash Princess", "reviews": [ { "rating": 2, "reviewerEmail": "john.doe@x.dummyjson.com" }, { "rating": 2, "reviewerEmail": "nolan.gonzalez@x.dummyjson.com" }, { "rating": 5, "reviewerEmail": "scarlett.wright@x.dummyjson.com" } ], "returnPolicy": "30 days return policy"},{ "id": 2, "title": "Eyeshadow Palette with Mirror", "reviews": [ { "rating": 4, "reviewerEmail": "liam.garcia@x.dummyjson.com" }, { "rating": 1, "reviewerEmail": "nora.russell@x.dummyjson.com" }, { "rating": 5, "reviewerEmail": "elena.baker@x.dummyjson.com" } ], "returnPolicy": "30 days return policy"}] I want to create a

Hi All,          I m trying to delete the old versions of interface and expression rules using Delete Rules/Constant version Smart service in Content tools plugin. I have passed the folder id(folder where interfaces and rules are present), number of versions to keep (10) but after executing the smart service, no versions got deleted. So, could anyone who used this plugin suggest what exactly i should do? Thanks in Advance, Pradeep

Hi,     Anyone here has worked on appian to salesforce integration in latest projects. Doesn't latest version of salesforce connected system covers almost all integration needs with salesforce ? like writing/updating to salesforce objects etc. Is it still recommended to use salesforce connector functions like a!sfcUpdate()?  For a brand new project, Is there still any reason to consider salesforce connector ? What are the pros & cons of using connected system versus connector regards to security , support etc ? What are connectors actually ? Are they native to Appian ? In my view , connectors seems to be outdated and better to use connected system and use salesforce SOQL/SOSL to integrate. Your thoughts & any real time experiences on this will be really appreciated. Regards, Mike

Hi Team, I am working on integrations to post data to another system. After posting the data to another system, I have to get the id from body. But the body is in text format and the id, success are concatenated. How to getch the id from body by any direct function without hampering the performance? Please suggest. Thanks in advance.

Hello Community, I want to use this plug in. Just wanted to know if the document uploaded gets deleted after our operation is done? Because we don't get asset id to delete the document uploaded afterwardsI tried to find this in the plugin documentation but was unable to do so. Please let me know if anyone has any updates.

Hi, We are using a styled text editor for the email body. Once the "Send Email" button is clicked, the email is sent, and an EML file is created. The emails in both Spanish and Portuguese are being sent correctly, with proper spacing and special characters appearing as expected in the translations. However, when generating the EML file, we encounter an issue where special characters are replaced with question marks or empty boxes. Additionally, spacing and line breaks are not preserved; instead, the content appears as a single paragraph when the EML file is opened. We are using the "Create EML File from  OOTB Poller" Smart Service to create EML File. In English is working properly and we are facing issue in Spanish and Portuguese

I have a excel sheet where the cell values are refered from different location as highlited below Here the value 4.00% we are getting from different document, if i try to extract this data using  function - excelreadcellsbynumber() I am getting below error. How can I extract such kind of data?

I want to know how to implement "Convert base64 values to Appian documents" without using an integration object. I have implemented a process that retrieves attachment information from an external database via HTTP connection and converts it into an Appian document.The process is as follows: 1. On the interface, execute an API request (an integration object) without "Convert base64 values to Appian documents", obtain information on 10 attachments, and store it in "local!fileList." 2. Perform a check: "If any of attachments 1 to 10 is not null, then the result is true; if it is null, then the result is false" and store the result in "local!notNullFile". 3. Press the "Get File (ファイル取得)" button.　 If the 10 file information items are judged to be false in "2.", nothing will be done.　 Only if the result is true will an API request be made with "Convert base64 values to Appian documents" enabled. 4. When th

Hi Team, I have configured a webApi to download CSV document on click, it's working when I use it in web browser but the same is not working when I use it in mobile device (Appian Mobile application). Could you please suggest the alternative ways to achieve a document download on single click? Thank you in advance

Hi all, I'm trying to set up an Integration that can send files from Appian to an Azure Blob Storage. I have the URL to the storage and the required SAS token, but I am not sure how to set it up properly in Appian. I created a HTTP Connected System and set the SAS token as a parameter. However, when I try to test the request via an Integration I'm receiving a 409 "Public access is not permitted on this storage account."  I was able to successfully connect and upload/delete/modify data via the Azure Storage Explorer with the same token, so I'm confused why this isn't working. An issue with a firewall? Mistake in configuration?  Appreciate any insights, maybe someone else had the same issue before and was able to solve it. :)  Best, Matthias

Hey AC, Does anyone know if we can use TAB as a delimiter option in the 'Import CSV to Database' Excel tools plug-in? The comma (,) is already provided by default which works nicely but was wondering if there is an option for TAB.If so, what would the character look like?

Good afternoon, I am having a problem when using the plugin, both for encrypttext and decrypttext. I am trying to access via SCS and I always get the error "Error encrypting value: This plug-in [com.unionbankph.plugins.aesencrypt] is not registered to access secured values ​​for the given external system key [Key]. Check the external systems plug -ins list in the Administration Console." even though the plugin is correctly in the credential's plugin list. I am currently using them in the following way local!base64Key: decodebase64string("pruebaencript"),local!eas: fn!encrypttext(valueToEncrypt: local!valor,scsKey: "pruebaencript",scsField:"Key",iv: local!base64Key), Thank you so much

I am trying to generate pdf from docx. The input DOCX file is the output from a MERGE DOCX smartservice. So basically its a merged doc(few docs are merged to single docx). Issue is PDF to DOCX/PDFfrom single docx/PDF from Multiple docx is puling only the first document from the Merged doc to convert to PDF. Rest of the docs in Merged docs are not getting converted in PDF. Any solution for converting merged DOCX file to PDF ?

Hello we have integration with an external system and once we add the document, we use Get file to retrieve the document. In the Get File Integration if I use convert Binary to Appian document it works fine and stores the document in Appian. But we do not want to store the document in Appian, we just want it to be a downloadable link. Converting the binary to a document using todocument() to display in a!documentDownloadLink.. results in an error saying ID Not found.

Hi All.We want to understand if we can receive message from AWS SQS and start a process model in Appian. Can we use receive message event configured to receive to message from external to process type to achieve this and if yes, can anyone please tell how to test that?

Hi All, Currently i am working on requirement where user select some columns on UI and that columns contains Space, +, & ,-, with these special characters.  Example: Alpha + Beta Alpha & Beta Hello World(y/n) any many more with special characters. but while exporting data through export to excel plugin when configured above headers name its throwing an error. Error Message: Either selection or filters are invalid: The alias [Aplha/Beta] cannot be used because it contains illegal characters.  The alias must contain only letters, numbers, and underscores, and must start with a letter. (APNX-1-4505-009) Is there's any way that we can achieve this piece of functionality.

Hi I need to validate if the correct excel is uploaded by validating its content . I have different excel upload for different activity. If the user uploaded wrong Excel and do the submit it should display that excel is not for this activity .  Is there any way to do that. Can anyone suggest a way and how to implement it.

We have an oauth2 authorisation with client Id , client Secret  & scope to connect to an api. We already have a connected system configured for this . This is working fine & we are getting expected response from api. Traditionally in our organisation we have a process model per application  which runs every 60 mins which generates the token  & writes to the token table. This token from db is accessed and set in the the header of the request as Authorization: Bearer ******. But it seems our code is working even if that Authorization header is deleted from the integration. It seems the connected system is adding the Authorization header to the integration request and the process model to token generation is not required at all. Does this a ring a bell ?

Hello, I'm trying to generate document from XML code. I have already seen many of the community posts, I followed the same pattern to generate doc using xml code, but I'm getting an error, says that syntax error in template. Please let me know what i have done wrong here. ERROR:"Syntax error in template ""fr.opensagres.xdocreport.document.docx.DocxReport@6c1fb8c6!word/document.xml"" in line 4, column 4957:" & fn!char(10) & "Encountered ""name"", but was expecting one of these patterns:" & fn!char(10) & " "".""" & fn!char(10) & " ""..""" & fn!char(10) & " <DOT_DOT_LESS>" & fn!char(10) & " ""..*""" & fn!char(10) & " ""?""" & fn!char(10) & " ""??""" & fn!char(10) & " ""!"&quot

Hi Everyone, I am facing an issue with the "Import Excel to Database" plugin. When reading the Excel file from the mail poller, it is not loading into the staging table. However, if we copy the same file to the local system, open it, and save it again, the data is successfully loaded into the staging table. Upon reviewing the system logs, I found the following error: [Senario:File was not ingested scenario]. 09:08:21.599 [Appian Work Item - 191302 - WorkID 79 - execution01 - process 268462146 - model 172 : ExpressionGroupRequest] ERROR com.vuram.plugins.documentencrypt.CheckDocumentEncryptionUtil - Unable to process document Any Ideas would be appritiated. Thanks in Advance!

While invoking a POST webAPI from Postman, I am getting error as below: "Unable to get Issuer certificate" . Authentication used here API-Key. Passing as Header: Appian-Api-Key What can be possible reasons?

Hi, im new in appian. I create a get api integration which recieve multiple lists those lists recive another ones. Also i create a expression rule to parse this information with my CDT. On my forms i call this rule and it works with text information but not with lists.  This is my interface: This is my rule expression: This is my CDT:

Hi there. I'm creating a new Connected System object to connect to an Oracle database. I have to fill the fields related to the Connection URL, User and Password. Considering that when I deploy the application to the production environment I will need to change the connection settings, is there a way to get this information from a properties file instead of setting this object again in the production environment when the application is deployed? Thanks in advance.