Extensibility

I have button click in appian UI which i need to use for consuming API from APIGEE layer. This is the two APIs we need to integrate https://it.api-dev.honeywell.com/v1/premiumFreight/appian/validateRequest for authorization and access token link is https://it.api-dev.honeywell.com/v2/oauth/accesstoken And input json i have added in the insert code I have and API url and access token to pass it to the headers of the api .Can anyone help us to know how to do this integration?{"row":{ "orderDelNumber":"8105050724", "orderDelItemNumber":"", "PO_SO_STO_INDEL_OUTDEL":"OD", "Source_System":"BID" } } Thanks Sunu Sam

Hi All,  I'm trying to pass JSON object in the startprocess but some how I'm not able to send all the attributes at one go  Here is the sample JSON I'm passing  {"CompanyName": "Company","Category": "Information Technology","SubCategory": "COnsulting","Definition": "On Call","ShipToState": "AK","invoiceDetails": [{"InvoiceNumber": "3425638769","InvoiceDate": "1/28/2022","InvoiceValue": "400.00$","InvoiceDueDate": "2/22/2022","InvoiceBalance": "300.00$" },"InvoiceNumber": "3425638769","InvoiceDate": "1/28/2022","InvoiceValue": "400.00$","InvoiceDueDate": "2/22/2022","InvoiceBalance": "300.00$" ]} In the above JSON I was able to get all the individual attributes into the process model except the  Invoice details Any help is much appreciated  Thanks  

I am recieving the following error trying to connect to OpenText "Failed to connect to the external system [key=opentext]. The site-wide credentials may be incorrect. Please ask an administrator to update the credentials in the Third-Party Credentials page in the Administration Console. Connection failure details: Unexpected document! Received: HTML document"

Hi  My dataset has multiple entries of working and non-working days in excel. I want to update the working and non-working days in a calendar. I am reading excel file using readexcelsheet paging function and generating calendar process variable by using read calendar method . While iterating the rows in excel as an output it just updates the first row only. How to read all the rows in excel.

Hello Appian Community, We are facing an issue where Appian is generating a JSON message to an external system and the external system is sending Appian back a large JSON file that has XML in an element of the JSON returned. This XML doc can exceed 5MB because of Base64 string docs stored within the XML. Appian will need to parse the XML out of the JSON response and send that on to a separate system. The issue we are seeing is the response exceeds 5MB so we cannot have the "Return raw response body" set as the Response Body Parsing. We cannot use "Convert binary to Appian document" in the Response Body Parsing because we have to parse the response to get the XML from the JSON. We are attempting to use "Convert JSON to Appian value", but when indexing into fv!Response.body.fieldName we see an error thrown "com.appiancorp.suiteapi.content.exceptions.InvalidContentException: Invalid Content ID".  We have tried different extensions for the

How to track and display in the google map 

I am trying to get the location & weather of the user, but I am only getting the location weather  of the Appian Server en Germany, I am using https://api.weatherapi.com/v1/current.json?key&q=auto:ip.  , please any help?

We have a requirement to embed excel on the Appian UI and this Online Office Integration Plugin seems to be useful for us. However, we are getting below error   I know this might be a silly question , from where we get WOPI Client URL. If anybody has already implemented this can you please help us here. We are trying to do a short POC so that we can show it , we are using our own office 365 account for testing purpose.

I've created a HTTP connected system by passing all the required parameters(sample values) as shown in Fig. But when I export this object and download the customization file, it does not specify SCOPE attribute at all.  Anyone has any idea, why Appian is not adding this attribute to customization file ?    Then how can we maintain this in all environments ( Each environment SCOPE attribute is different) without manual update.

Upon reading or uploading an excel file receiving the following log error 2022-01-20 21:09:00,529 [ajp-nio-0.0.0.0-8009-exec-6] ERROR com.appiancorp.ps.exceltools.expression.ReadExcelFileFunction - Failed to read zip entry sourcejava.io.IOException: Failed to read zip entry source I am uploading a .xlsx file but it is saying failed to read zip entry source. 

Hi All, I am trying to use "Receive a file from RDBMS BLOB" smart service and it is appending zero every time in the file name. Can anyone please help me on this. Any reply is appreciated. Thanks in Advance, Neha Raghuvanshi

Hello, I am using Send File Over SFTP smart service and I'm supposed to place a file in docfiles folder of F drive in the destination remote VM. So I've given the remote file path as "F:/docfiles/sample.pdf"  However File is not being transferred to remote file path and I am receiving No Such File error in Appian though I have sample.pdf available in Appian repository. Any thoughts pls ? Error transferring file to SFTP server2: No such file

Hi Folks. I want to retain the same file name while fetching details from integration. Please note contentBytes stores the document fetched. But I'm getting below error: Request your suggestion on how can I achieve this in keeping the same file name as passed.

Hi Everyone, I'm trying to invoke MS Graph REST API to fetch email with attachment and that the attachment in response body location is fetched correctly but When specifying fv!result.body.value.name in 'Name', we get error as shown above. Does it accept only static names?  As our requirement is to retain the same name of the attatchment as fetched. Need your suggestions on the above query.

I would like to know if we have any replacement or equally functioning Deprecated Export CDT to Excel. I am aware we have Export DSE to Excel but my requirement is to export the local data into Excel and we are not storing data in the table.

Hi, Mail server to database smart service is not working for 21.4 appian update. Its working fine with same configuration for 21.3.  Getting error [Cipher suits are not appropriate] may be the security needs to be updates in java.securities file.

Hi Everyone, Is there a way where appian can fetch the password of the loggedInUser. If possible, please suggest an approach

I need the correct format to create inputs when calling the Execute Stored Procedure plugin from an expression rule.  Here is my entire rule. I want to send an integer as an input (and ri!num is an integer) into a stored procedure and retrieve the results as the dataset is too large for Appian to handle comfortably.a!localVariables( local!spResult: fn!executestoredprocedure( dataSourceName: "jdbc/Appian", procedureName: "jsonValTest", inputs: { id: ri!num } ), local!result: if( local!spResult.success, local!spResult.result[1], local!spResult.error ), local!result )Here is my stored procedure: The SQL query when run as a query minus any parameters works. Have I fouled the SQL procedure or do I have the syntax wrong on the execute stored procedure (or both)? Thanks in advance.

Hello All, We have Appian setup on premises and want to expose & reuse processes to new Appian mobile app. Is there any way to embed on-premises processes/interfaces in Appian mobile app?  Thanks, Bhushan

Hi Appian DevsI need a bit reference from you to use the right plugin to convert a docx file to pdf which can carry the correct formatting including font style, font family, special characters, ###tags### and text colors correctly during the conversion from docx to pdf.Can you help me in picking out the right plugin?

Hi, in our system,  we have a functionality to create a document from an url of Reporting Service. We use the following smart service: In Input Body, we use the function httpgetbinary() (from plugin Web And XML Extensions), where endpoint is the url of Reporting Service that generate the document. However, the plugin doesn't exist anymore and Appian suggests to use Integration Object to substitute it. However, when we try to use it, we receive the following error:   So, we find Microsoft SSRS Document Integration Plugin, but there isn't no documentation about this plugin and we don't know the value of input Device Info. Could you help me to understand what kind of value it's necessary to insert? Or Is there another way to get a document from Reporting Service with NTLM Authentication? Thanks in advacne. Regards, Juri Monti

Hi, How can we take a screenshot of the interface when we click on the button?

I'm trying to  connect to a system that  requires oauth 2.0  but  i want client credential in order to just connect with one global account for all the user to retrieve  the information. the site that I'm trying to access doesn't allow "oauth 2.0: client credential grant", right now only   the   "oauth 2.0: authorization  code grant "   is available. The way that quickbooks works is:   Step 1: the  site  can give me an access token and a  refresh token for  like a hundred  days  that's  why i'm trying to figure out  a  way to pass this tokens through the integration is there any way to do it ?.  

Want to know the best approach for E-sign functionality (Like username and passwords should be in each and every task before submit button ).  

We have a process that successfully intakes excel files but below is a use case where the file is not uploaded/error occurs: Use Case 1 - Fail 1. download the excel file from elsewhere (.e. shared site) 2. File is stored on desktop/downloads folder 3. Open Appian > Select file to be uploaded from downloads folder 4. File upload fails Use Case 2 - Pass 1. Open same file that failed in Excel on desktop 2. Rename the file in anyway (i.e. add number 1 to end of title) 3. Open Appian > select new renamed file to be uploaded from downloads 4. File upload is successful Why is use case 1 failing? Can we change something so it is accepted?