Extensibility

Hi I am using the PDF from Single Docx ( With Fonts ) Smart service to convert my docx file to PDF. Everything is working fine, my document is getting generated and all, but there is one issue i.e I am not able to display text in bold even though the docx have the text in bold. I tried including the Arial Bold ttf font file to the smart service, but it doesn't seem to work ( I had attached arial bold file because my entire contents in the docx file is in Arial font and I have made some parts of it bold )  Docx File with bold text :  The generated pdf :  If you see the heading of the table as well as table column headings are not bold  Can anyone help me understand how to make the text bold ?

When we execute the API Endpoint to load the data in DB, we get Generic Error Message " 500 There was an error writing to the data store"  Is there a way to capture the Actual Error message and Return it as a message instead of the above? Example:  Details: javax.persistence.PersistenceException: org.hibernate.PropertyValueException: not-null property references a null or transient value Following is the code :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" } ) )

Hi,everyone I was using Post Method and when I tested with the expression rule, I was able to get 355 rows of data.When i tested webapi only 300 lines are responded from Webapi response. Can I change the size limit or number of lines for webapi?If so, where can I change it?

Hi,  We need to get access tokens from our id provider and we had thought about using a Connected System with the OAuth 2.0: SAML Bearer authentication method but the documentation says:  "As soon as Appian gets that SAML bearer assertion, it decrypts it if necessary and signs the user in. Then, for each Connected System that uses the OAuth 2.0: SAML Bearer Assertion Flow, Appian will immediately pass the SAML bearer assertion (along with the Client ID, Client Secret, Scope, and any Additional HTTP Headers set in the connected system) to the authorization server at the Token Request Endpoint. Appian will always pass the SAML assertion unencrypted" Our id provider requires that scope, grand type and assertion must be provided into the body and we have some questions:  Where does the SAML assertion travel, header or body? Can we get the SAML assertion in some way? Can we move the scope from the header to the body? Thanks in advance

Hi all.  The Appian Designer/Plug-Ins tab shows a long list of plugins that are installed on my cloud instance. I would like to create a list of the plugins that are actually used by my application. I tried searching the forums and found several answers that suggested exporting my application then searching through the xml files to find the plugin names. After exporting my application, I found a file "/META-INF/plugins.txt". Does this list the used plugins? None of the answers I found talked about this file, but they were several years old, so its likely things have changed. thanks Matt

Hi,  I am trying to generate a pdf using the pdf from doc smart service, but once the pdf is generated the header is not being present. Can someone please help me out on what the issue could be ? Attaching the ss of my process model for reference

Hi!Is there a way to check when and by whom an API Key was deleted from the Admin Console Web API Authentication?

Hi, I'm using excelreadcellsbynumber to read excel file excelreadcellsbynumber( excelDoc: ri!template, sheetNumbers: {1} , columnNumbers: { 7 }, rowNumbers: {7,8,9,10} ) it returned null value from row 8, 9, 10,  which is not correct Because when I use readexcelsheetpaging, it returned the correct values readexcelsheetpaging( ri!template, 0, a!pagingInfo(1,100), 8, "", 0 ),

"I am working with the MS Graph Email Poller plugin to read emails and save attachments as .eml files in an Appian document folder. However, I am having difficulty locating the SCS external system key and the correct JNDI name. Could someone please guide me on how to set these up?"

hi all  related to the apache avro serialisation of data , wherein i got an error in integration in the result saying 500 status code and integration failed and avro serialization error.

I am using DOCX from dynamic template and able to generate document having multiple pages (generated dynamically and depends on the size of passing array.) For each entry I have a header and because of the data length, Header is not coming on top of each page for the same item content.(Required: Header to be displayed on the pages till the length of the content of the item) How can I make sure that header will always come on Top of every page of same item content and next header will start from next page always with new item content ? Is there anything we can configure in Dynamic template? I came across one solution: But this is again a lengthy process, So is there any other solution that can be tried apart from the screenshot attached?

1. Current setup we are generating the JWT token using and external system key and the details we are stored in the Third-party credentials in Appian admin console, and we are using the JWT token to generate the token, and this approach works well. 2. Problem The external system key expires every six months. This requires manual updates to the key in the third-party credentials in the admin console. We have access to a Realtime API to retrieve the external system key dynamically. Is there a way to generate the JWT token without manually updating the third-party credentials every six months I need to build like this, I have a process first I will trigger the API to get the external system key and I will pass the key and i have to get the JWT token.

Hello, I have a use case where I need to download multiple documents from SharePoint. Currently, I need to do this in a process model and the only way I have found of doing this is by creating a loop within my process.  Unfortunately, I need to activity chain this process and by having this loop, I risk breaking the 50 node limit. My question is as follows: is there any way to download multiple documents from SharePoint using a single node within a process? Thank you

There is a database table where user can write into. I need to generate a dynamic template using the data from the table. Meaning I have a button or a link, whenever user click it, the latest template should be generated and downloaded. 2. And I want one of the column to be populated with a dropdown and user can only choose value from the dropdown, which also means the excel should be protected. Can we generate protected excel with only specified cells that can be edited How can I implement this?

Hi, I'm using readexcelsheetpaging() to read an excel, it has a blank row so I want to set stopReadingAtFirstBlankRow: false But I got following error: Expression evaluation error at function 'readexcelsheetpaging' [line 26]: The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB was not able to produce a value for typed value TypedValue[it=26,v=0] as java class java.lang.Integer. But when I removed stopReadingAtFirstBlankRow it works fine.

Hi, When I was reading an excel file uploaded by user, how can I identify the max row that has values? Otherwise if I read to the row that has no values I'll get error, I'm using excelreadcellsbynumber()

I am trying to move the file into file system by creating a folder on the destination path. I am passing folder parameter using constant. This is moving file in file system but not creating folder. Please guide me what I should configure so that it will create folder and move file in it. ++[mention:9a3c4b933d674b319102bb3e59083770:e9ed411860ed4f2ba0265705b8793d05] 

Hi everyone, I’ve created a GET method Web API that returns a list of countries in the HTTP response. The Web API also includes a query parameter for the username. Now I need to log each Web API call by saving the endpoint name, response body, query parameter, and the current date and time into my Web API Log record. However, the issue I am facing is that Appian doesn't allow the execution of the WriteRecords smart service within a GET method Web API and gives me this error: Smart Services cannot be executed in Web APIs that have a method of "GET." Does anyone have any suggestions on how to handle this case without changing the API method to POST, PUT, or any other? I would appreciate any help. Thank you! For reference, here’s an example of my Web API code: a!localVariables( /* Retrieve all avalaible countries from the corresponding Record Type */ local!countries: a!queryRecordType( recordType: 'recordType!ABC Country', paging

I got 2 of this. one is Intergrate Designer and one is API Web designer. I already configured all the parameter and the endpoint seem the same from 2 of them. I use test request and both of them return success (200) but only Web API designer post data to database while Intergrate Desginer doesn't. Integration Designer :  Web Api Designer: Can anyone know what is the issue and how to resolve this one.

Hello, I have an issue with the map, which just won't appear in the interface. I had this issue a month ago, when I couldn't see the map, but my colleague did. A couple of weeks later the situation was the opposite (I saw the map, but my colleague didn't). Now the problem is worse - none of us sees the map...

Is there any way to show a loading animation like a loading circle instead of an interface while the integration is running?  For example my main site is built with 8 interfaces where one of the interfaces calls an integration that might sometimes be slower (can take up to 5sec to load). In the current version if I force the backend API to take longer to load and then try to load the main site the integration call blocks the loading of the whole page while the data is loading.  What I would optimally like to have is that all the other interfaces get loaded while the one that calls the api shows a loading symbol until the data is loaded from the API.  If anyone has any suggestions on how to achieve this please let me know.  Thanks, Jan

Hi Appian Community! Does anyone have good recommendations for replacements for the unsupported plug-in Republish Model as Different User? My organization uses it in lower environments whenever an individual developer modified a process model and daily, there is a scheduled process that republishes all the modified process models as a service account to prevent issues of process models being "stuck or frozen" when a developer leaves and their account becomes inactive. TIA

Hi,  I am running into this error  "An error occurred in executing an Activity Class."  while attempting to Export Data Store Entity to Excel (smart service). We are only facing this issue only in one of our ENV after upgrading from 22.3 to 24.2 (On-prem). I have checked to see if the PM and datastore is published, no strings are used in pointing the Datastore entity. Please help me understand this.

hello in our application we're using a!sapInvoke to query some data from SAP. the integration were working till last friday but from this week they're failing. here's an example code of one of this expressions: a!sapInvoke( scsExternalSystemKey: cons!LEASE_SAP_SCS_EXTERNAL_SYSTEM_KEY, usePerUserCredentials: cons!LEASE_SAP_USE_PER_USER_CREDENTIALS, hostname: cons!LEASE_SAP_HOSTNAME, clientnumber: cons!LEASE_SAP_CLIENT_NUMBER, systemNumber: cons!LEASE_SAP_SYSTEM_NUMBER, bapi: "BAPI_MATERIAL_AVAILABILITY", importParameters: { MATERIAL: ri!SAPcode, STGE_LOC: cons!LEASE_MATERIAL_STORAGELOCATIONSELECT_LOW, PLANT: cons!LEASE_MATERIAL_PLANTSELECTION_LOW, UNIT: ri!unit }, tableParameters: {}).result which is returning the error: Could not connect,message:Failed to connect to the external system [key=leasesapdev]. The site-wide credentials may be incorrect. Please ask an administrator to update the credentials in the Third-Party Credentials page in the Administration Cons

Hi! When I use an integration in a process model, I get the following error:The integration execution time exceeded the configured timeout.However, the service I invoke through the integration works fine, only the Appian integration gets the error even if it worked as expected. How can I fix this? Is there a way to give it more time so it doesn't get error by timeout?