Integrations

Hello everyone, we have a new requirement to connect JDE integration I am not sure how to connect JDE from apian can anyone guide me please Thanks!

Hello, i have a Web Service and i save the Result.body response as in a process variable map. For auditing reasons i need to save this result as a *.json file that just needs to stay in the Knowledge Center for now. How can i achieve this? I have tried using a template but from Map to document i loose all the Json elements. Thank you

Hi Community, I am trying to generate a JWT using createtokenwithsecretkey() in JWT plugin (using HS256). When I use the generated token and hit the Tableau signin API, I get signin error and JWT is invalid ( details error code: 10083). However, I use the same parameter details in a python code and use the token generated, the API returns me a successful response. Can anyone help me with the issue on Appian side please?  createtokenwithsecretkey( externalSystemKey: "jwt", /*Set the third party credentials in Admin Console */ iss: <tableau connected apps clientID>, aud: "tableau", typ: "JWT", /*jti: fn!generateuuid(123),*/ exp: 43200 )

Hello Community members, I am using the 'Get Base64 document from database' smart node to fetch a document from the database. As part of the new requirement, I need to fetch multiple such documents from db, create a ZIP file and allow users to download it - all in one click. I tried creating a web API to call an Appian integration that starts a process. The process uses either MNI or looping flow to fetch all the documents, creates a zip and terminates. Both options seem to be unreliable as not all the docs get downloaded using a loop or MNI with activity chaining (plus it's not best practice to use MNI + activity chaining). Have you encountered similar problems in your project? If so, do you have a solution for me?

I have requirement to call service now API before every manual deployment. Appian support team should not be able to deploy package in Production if change ticket from service now is not approved or not in  start time and end time window. I have achieved the integration by calling service now API but I am not able to restrict the "DEPLOY" button on Appian Production screen based on the check. Is there any way we can restrict the deployment here?

I have tried with Web Content Component it will embed page with provided source url but it will ask for logon and password again.

Hi, While getting data from DB using in WebAPI, getting Z appended only in the datetime field as below. WebAPI: a!localVariables( local!Details: rule!XXX_DetailsView( batchSize: http!request.queryParameters.batchSize, startIndex: http!request.queryParameters.startIndex ), a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson(value: local!Details) )) It's a simple GET API. NOTE: rule!XXX_DetailsView - This is queryEntity used to get data from View. Anyone can advise, what could be the reason, and how can we remove this extra 'Z'.

Hi, I am trying to integrate a web api in Appian enviornment but getting error that The connection is not secure even the web api is secured by SSL certificates.  Apart from this, I am able to access web api in postman without any errors. Please suggest me what should I do to fix this.

I am trying to set up an OpenAPI integration based on the JSON provided in the link below, but it is giving me an error message "The selected OpenAPI document could not be parsed" when I upload the document. Does anyone have insight here? I am not seeing anything in Appian's documentation that would assist troubleshooting.https://docspring.com/api-docs/v1/openapi.jsonSource: https://docspring.com/docs/api/openapi.html

DocuSign integration I have seen another project where when they create an envelope, they send a draft envelope to DocuSign. When the envelope is created, they call an integration object to retrieve a url like below: Apologies for the blurry images, but this is the setup to this integration object: In the Response Body in the first image, there is an http url. They are able to take that url and provide it as a link in an Appian interface, so that a user can click on that link and immediately see the DocuSign draft envelope configuration screen, where they are able to configure signer and recipient information before sending the envelope off to be signed. We want to replicate that in our project, however, we're using Appian's OOB DocuSign objects. Our connected system is below: We're not able to generate a similar URL. When we create and send envelopes, this is the only thing we see: If we try to get envelope definition (operation Get Envelope Definition), this is all we

Hi All, I want to retrive my credentials stored in third party credentials in Admin Console or in Settings page. I have tried a!scsfield() and a!httpAuthenticationBasic() but no luck. Can anyone suggest how can we retrieve the data stored in secure credential store to integration object. Thanks In Advance.

Hello, We've successfully implemented the web API document upload template in Appian, fetching documents and metadata from an external system. However, we've encountered an issue where the file name is consistently labeled as "Untitled Document" in the process. Any assistance in resolving this matter would be greatly appreciated. Thanks

How to detect/fetch all base64 values using Gmail API response in Appian? Currently, I am using this End point/URL "">gmail.googleapis.com/.../messageId".

Can Appian whitelist by URL instead of IP address?

Hi all,We need to send a document from appian to an external system which receives document as a part of json with document converted into base64 string. For example:{ "name":"Document_name", "document":"base64 string encoded document"} The request json will look something like this. How to convert document into base64 string in appian? Do we have any plugins for that??

I've created an WebAPI to save data by a!writeRecords(by WebAPI creation wizard) it worked fine when I test it by "TEST REQUEST" button, but when I call it by an Integrations, got error of {"message":"Write request has failed","error":"The input \"Records\" refers to an invalid record type. The record type does not exist, has been deleted, or the user does not have sufficient privileges to access the data."} I have create a Service Account, add SA to the security config with Administrator permission, to all objects, include WebAPI, RecordType Also add the API Key(Appian-API-Key) to Connected System. Can anyone help me?

Hello, I am getting this error while integrating. Can anyone please suggest? I have checked all the parameters and headers and they are good. Please suggest. The external system did not understand the request error-result-guidance The request was missing required details or was improperly formatted HTTP/1.1 400 Bad Request Next Steps Make sure that you are providing all required headers and parameters and that those values are valid Check the request and response for more details Review the external system''s documentation for information on what may have caused the problem

Hello, I'm creating a Web API for the first time, and I'm facing issues, perhaps due to not knowing how to test it. I have the Web API set up, and when I click the button to test it, it returns the value correctly: However, when trying to do it from an integration or using Postman, it doesn't return the response, but rather the following: What am I doing wrong? Thank you very much.

Hi Community members, I have requirement where i need to send the status to process model, if My integrations fails. Can someone help me. I have configured it this way,  Have created a PV of Error and its of type IntegrationError, but still if integration fails am getting blank value in Error (PV).

I am trying to get the data from Integration , there is multiple field which is more than 4K characters , is appian having restrictions to receive the no of characters and show the data in GUI ? when i test the integrations  , I am seeing the data truncated  , any Input is greatly appreciated ,? if 4K is max limit , whether we need to sub divide them into multiple fields and show them , Please advise

We are trying to fetch access token in order to integrte with gmail. To get the access token, we need JWT, which comprises of header, claim set and signature. The header and claim set part are clear. Can anyone help to understand how to compute this signature in appian? Is there any plugin available in the market?

I have created a webapi - Get method, I have created a basic user and added that user in a Group and attached that Group in that WebAPI. Now I used that basic method and called that using PostMan , it works fine. Now I deleted that basic user from that group & created a API Key and attached that Service Account in that group.  Used the API Key & Value in PostMan, I am getting an error  Pls let me know, what is the mistake I am making here. Thanks in advance.

I have two applications with API Integrations configured. Each application connects to the same gateway - Request Reply Bus (RRBUS) using the same client certificate.  Because the host is the same, how can we configure the applications to use separate client certificates? According to this post: https://community.appian.com/discussions/f/integrations/21467/adp-ssl-certificate-usage-in-integrations "This is done automatically by matching the url in the certificate to the server you call." Any input is appreciated.  Thanks!

Hi, I have a question, im creating a web api to return data from a query and i have to remove a column from the response. For example: I have an expression rule to bring me all the centers we have and it returns  "id" : null, "address" : "null", "officeName" : "null", "countryId" : null, "isAvailable" : true How can i remove the column "countryId"?

i have requirement where i need to pass start date ,end date and some mail address to external system (api) . how to send this data using integration and which method i need to use (get/post)Upon startdate api call should happend  and upon end date it revert the api call