Integrations

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 Id, Name, Reference_Type__c, System__c, Seq__c from SRS_Service_Request_Related_Order__c where RO_Service_Request__c " ,"='",ri!serviceRequestNo,"'");How to write above for fetching data for multiple financial id's involved , ri!serviceRequestNo 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

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 

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,     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.

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

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?

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 ?

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.

Does appian support wild card certificates? in the form of *.dev.orgname.com

I have a REST service that posts a lot of data to a table in Appian (136k+ rows).  The problem is the primary key in the service is not the same primary key that Appian is using.  I cannot match the keys because, the service's key is unpredictable.  Government data, yea!   For my REST post I simply need it to find the record with a matching value (if it exists) then update it, or else create a new record. a!localVariables( local!value: cast( 'recordType!{b44d0eeb-090e-4c8f-b858-1f684423adbc}DCQ Weekly Extract', a!fromJson(http!request.body) ), a!writeRecords( records: local!value, /* * Construct an HTTP response to return to the caller */ onSuccess: a!httpResponse( statusCode: 200, /* * Set an HTTP header that tells the client that the body of the response will be in JSON format */ headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, /* *In

Hi All, I need to connect and post data in to an existing table in share point. How to connect with that existing table and in where can i find those details in microsoft documentation. Thanks, Ganesh.

Hi Team, Where should we see the additional configurations of the web api we create like rate limit, timeout, payload size limitations, retry threshold etc? Is it modifiable for cloud environment? Along with that, I also have few other questions below:  1. when we expose our data via API, as an additional security, do we have any methods to black list/white list system IPs? 2. what's the good practice regarding rotation of authentication credentials in web api? 3. what is the typical response time for webapi?  Thanks in advance!

I have two records. I prepared the data attached. The records are: one is LTM GROUP and the other is LTM USER. Both are related records. I have heard that we can store data in the base and related child record in one shot. As GroupId is the primary key in LTM Group (autogenerated), plus LTM User has a foreign key named userGroupId, and obviously, this table also has a primary key userId which is autogenerated. Can you please help me with storing data in tables with the help of writing records in a single shot? /*Group*/ { recordType!LTM GROUP( LTM Group.applicationkey : 1, LTM Group.appiangroupkey : 25, LTM Group.name : "Admin", LTM Group.updatedby : "rt343", LTM Group.addedby : "rt343", LTM Group.dateadded : fn!date(2025, 2, 25), LTM Group.disabled : false ), recordType!LTM GROUP( LTM Group.applicationkey : 1, LTM Group.appiangroupkey : 26, LTM Group.name : "RTR User", LTM Group.updatedby : "rt567", LTM Group.addedby : "rt567", LTM Group.dateadded : fn!date

Hi Team, I need to fetch data from a GraphQL API endpoint, but I'm unsure about the connected system required for the connection. The client has provided the ClientId and ClientSecret for AWS Cognito and mentioned that they are using SRP (Secure Remote Password) Authentication. However, I'm not sure what additional information is needed to establish the connection to the GraphQL service. Can you please provide more details?

Hi Team, I need to fetch data from a GraphQL API endpoint, but I'm unsure about the connected system required for the connection. The client has provided the ClientId and ClientSecret for AWS Cognito and mentioned that they are using SRP (Secure Remote Password) Authentication. However, I'm not sure what additional information is needed to establish the connection to the GraphQL service. Can you please provide more details?

Hi Everyone, I need to implement functionality to read, write, and update specific JIRA tickets through an integration between Appian and JIRA. For this, I'm referring to the JIRA API documentation: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-issue-issueidorkey-get   To authenticate, I plan to use OAuth 2.0 (Authorization Code Grant) as outlined in the documentation here: https://developer.atlassian.com/cloud/jira/platform/oauth-2-3lo-apps/   I have already created the necessary app in the Atlassian Developer Console for OAuth 2.0, and I successfully set up the connected system in Appian. However, I'm encountering an error while trying to create the integration system. Could anyone please assist me in resolving this issue and help me complete the Appian-JIRA integration?   Thank you!

All, I am trying to using Google Drive connected system(https://docs.appian.com/suite/help/21.4/google-drive-connected-system.html) , to create folder, upload and download documents  to and from google drive folders. Then API  operations  (like createFolder, uploadFile, downloadFile, etc) all work perfectly  on a personal folder of an auth user, but   the same operations are not working on a SHARED folder in google drive, Has anybody got that working with a Shared drive?  I checked out some documentation on google drive APIs  at (https://developers.google.com/drive/api/v3/enable-shareddrives?hl=en)  and found out that supportsAllDrives=true  parameter is required to enable these operations on a shared drive. But there is no way in the connected system to pass this information.  Any ideas? Any suggestion?  Thanks Pal

Hi, I am trying to connect a 3rd party system which uses OAuth 2.0 Password Grant Type authentication, as it is not supported by Appian connected System. I have created a separate integration object to get the access code where I am passing below fields in request body. "client_id": {client id} , "client_secret": {client secret}, "username": {username}, "password": {password}, "grant_type": "password" Getting this error  "error":"invalid_request","error_description":"The grant type was not specified in the request". I tried creating token using POSTMAN and there it was working fine. Attaching screenshot for both. POSTMAN Response: Appian Integration Response:  

Sorry if I'm missing something obvious/another tread on this topic, but I haven't been able to find anything related after digging for a while and banging my head against the wall on this. Is there a way to natively pass variables into an integrations relative path?  The goal is to have some user input field for that variable to pass through to the external endpoint, who's required format is along the lines of:  base_path / relative_path / {variable} / relative_path2 I'm looking to avoid as much custom code as possible, but any help/advice would be appreciated!