Data Fabric

Can we export charts or images in excel?

Hi, I need some ideas. I am accessing external data using an API and building a record, type - Web Service to store customer information. The API requires a group name to return customer details. Example: Company A → 20,000 customers Company B → 30,000 customers When you pass Company A, it returns the customer details for that company. Now I am facing a challenge. When i call only Company A it goes fine. when i introduce foreach for company B then it is not possible as the sync limit is 1000 by Appian.  I am using the Batch by Sequential Values method. In my integration, I have set paging to return 1,000 records per call. error message i get: "The Record Data Source cannot return more than 1,000 records in a single batch. Batch size was 2,000." Note: I cannot reduce the API limit below 1,000 records because we have many companies, and doing so would significantly increase the synchronization time. sample Code: a!localVariables( /* Call the int

I am using a!queryEntity() to query a DB table where I am only using 2 filters to fetch the results. I am also using pagination for it. Also, this issue is not occurring for all the records. It just occurs intermittently and it also resolves the moment we try to re query using same data. does anyone knows what could be the reason for it? This is the complete error: An error occurred while evaluating expression: XXXXX (Expression evaluation error in rule XXXX at function a!queryEntity [line 4]: An error occurred while retrieving the data. Details: Unexpected error executing query I doubt if the batch i set might be causing it? I have set the batch size to -1? Does it have any impact in query performance?

We have a Record Filter "INSURED" in a case level . For example we are having 3 insured names for a particular policy, we want only those 3 names to be diplayed. Currently all insured names from table are displaying. We couldn't able to pass any filter like rv record or any primary key to fetch the particular insured for policy. Is there any way to implement using record filter or we have to go with manual filters?

I am getting weired error while saving data to records. I have a table which has onlly three not null column. I am passing values to all of them. But I am getting constraint violation error for createdby_tcxt which is not even not null. I passed value for it as well. I checked DB structure, checked records many times. Even I am getting data into the process model to update. The error is like " Data constraint or integrity violation: the createdby_txt field doesn't have default value. Anyone has any idea why I may be faving this issue.

Hi, I am looking to set up this configuration in Appian and I'm not sure how to approach this. I am designing a task manager application where a single task can be assigned to multiple people. So in the interface form, it will list generic task details such as task name, description, due date, and who the task needs to be assigned to. If I assign it to Alice, Bob, and Charlie, then I want to create three tasks with each one assigned to each individual.  <Interface form> Create a single task to "Do Laundry" and assign to Alice, Bob, Charlie. <Data store> 1 - Do Laundry - Alice 2 - Do Laundry - Bob 3 - Do Laundry - Charlie This way I can see if each person has done their task. I assume I need to use a for each loop somewhere in the process model? How do I code this in the process model to create X number of tasks and write X number of records?

In many cases, we have to do join other than primary key for the tables as same can't be configured with sync Record type and ultimately, we need to depend on  Database views and we loose many capabilities of Sync Record type

I'm trying to write into a record and earlier it was getting written but now it just pauses indefinitely at "write record " node. no error nothing , no discripancy in data too

I understand that Record Types are generally preferred over CDTs in modern Appian development. However, apart from plugin compatibility (some plugins only support CDTs), are there any other real advantages of using CDTs over Record Types? In what scenarios would choosing a CDT be the better or recommended approach compared to a Record Type?

My Requirement is I need to fitch data from a view where all the columns are unique except 2 column data i need to show the unique data in the records page just filtering these two records. can you please help me with this using a!queryentity()

Hello! I'm wanting to create a Synced Record Type for Salesforce objects for use within Appian. I successfully created the connected system for Salesforce, but when I go to create an Integration using the Salesforce Connected System, I'm unable to get pagination to work correctly. The SOQL response shows the "nextRecordsUrl" and the first batch of records. However, after playing with the expression rule for the Record Type, I'm still unable to get the Integration to know that it should query the "nextRecordsUrl" instead of attempting the same SOQL query. Essentially, I can't get pagination to work. Has anybody had success building out a Synced Record Type for Salesforce records without building out a custom HTTP Integration, but instead relying on the standard Connected System? Any help is appreciated!

Hello — I would like advice on how to aggregate some data. ## Purpose- The goal is to trace daily changes in workers' working hours. ## Data structure- Each record represents a user's single work session and contains: - **RECORD_ID**, **USER**, **START_TIME**, **END_TIME**, **DURATION**- A user can have multiple sessions in one day, so one user can have multiple records for the same calendar day. Example:RECORD_ID | USER | START_TIME | END_TIME | DURATION1 | A | 12/23 10:00 | 12/23 12:00 | 1202 | A | 12/23 13:00 | 12/23 15:00 | 1203 | A | 12/24 10:00 | 12/24 11:00 | 604 | B | 12/23 10:00 | 12/23 12:00 | 1205 | B | 12/23 13:00 | 12/23 15:00 | 1206 | B | 12/24 10:00 | 12/23 12:00 | 1207 | B | 12/24 13:00 | 12/23 15:00 | 1208 | B | 12/24 16:00 | 12/23 17:00 | 60``` ## Required aggregation steps- First, aggregate these records by **user + work date** to compute each user’s total working time per day.- Then, calculate the **average daily working time per organizational u

Hi, I have a read-only grid with the selectable parameter enabled. Lets say as a user i select 2 or 3 rows in a grid and then when i try to filter the data using the user filter, is there a way to unselect the existing rows ?

In my application, I am trying to associate the same document with different Activity IDs. However, when I go to the documents section, I get this error, which seems to indicate that it is impossible to manage the same document ID on different activities. However, the relationship is 1 document, many activities. Does anyone know how to solve this problem?

Hi Team, I am using a record-based grid to display data. But unless search button is clicked, data does not get loaded to grid. Thanks, Kavya

Hi everyone, We are planning to connect Appian to an on-premises SQL Server environment. Due to security and network restrictions, Appian developers do not have direct access to the on-premises SQL Server. As a result, we are unable to directly inspect table structures or view data stored in the database during development. To support smoother development, investigation, and testing activities, we are exploring whether it is possible to view and reference on-premises SQL Server data from Appian. Specifically, we would like to understand the following: Is it possible to synchronize or replicate data from an on-premises SQL Server to the Appian Cloud Database? If so, is there a way to browse and inspect table data using a GUI similar to the Appian Cloud Database? Thank you in advance for your help. Hatsune

We have a database table where we store a reference to a Record Type (it could be the Record Type name, UUID, or a string like "()"). The requirement is to convert this stored value into an actual Record Type object at runtime so that it can be used in expressions or interfaces. For example: cast( 272, " 'recordType!{b12345-12345-12345-12345-c12345}ABC' " ) Is there any built-in function or best practice in Appian to achieve this dynamic casting?

I am trying to use a create new record action to insert a new record into my table and based on the grid I am showing to the user they only can see records associate to an related record. I would like to be able to pass in the primary key for that parent record into the record action so I can default that field to use that value and not allow the user to associate to a different parent on accident. It is possible that there is not data in the grid but I would still know the primary key of the parent record to pass in.

When creating or editing a record type, you can see the URL of the record list. How can I read this so that I can create a link button to the record list for the user? I don't want to see a single record, but the complete list. The solution is: a!urlForRecord( recordType: cons!SODA_PGN_RECORD_TYPE_PGN_REQUEST, targetLocation: â`˜TEMPOâ`™ ) I was just missing the function a!urlForRecord().

Hello, I have a question related to End-User Reporting tool. In the Appian Community it is mentioned that this tool was last updated on May 2023. Since then this listing has been archived. I would like to know if there are going to be any new versions or upgrades related to this tool in the future. Can we use this utility for future application building. Thank you.

{ { '1': { loggedInStatus: "Succeeded", timestamp: { sessionDeletion: "", lastActivity: "", login: "2025-12-03 07:43:17" }, sessionId: "abcb9532-b5f5-4e2f-8946-8f08a17e307f", status: "Active" }, '2': { loggedInStatus: "Succeeded", timestamp: { sessionDeletion: "", lastActivity: "", login: "2025-12-03 08:27:31" }, sessionId: "08ad7f98-85f6-4fd5-a072-6278731cbfef", status: "Active" } } }Here in this example I want to access a field "sessionId". I tried to wrap this using a!flatten () but still it doesnt work. Any help here ? Thanks in advance.

Some of the queryRecordTypes are working slow for us in prod. I am trying to monitor the performance and it has something 'performanceView.breadcrumb.recordQuery' highlighted. What does that mean and what part of the query/record it points to? Any idea Also, Appian do recommend using queryRecordType to get the data from the related records too but when I have filters and logical expressions applied to them they are performing slow.

Hi, I need to transform an image to base64 to be able to send via the Send E-Mail object. Is there a plug-in? thanks 

 I have a user filter with multiple dropdown and the drop down contains duplicate names of amendment but their application type and Line of business is different so there are duplicate names . As this is multiple dropdown if we select one duplicate name another duplicate name is also getting selected thats fine , but when I deselect one its not deselecting both, aby idea how to handle this In the above picture I selected blood , but if I deselect one blood , its not getting deselecting unless I click on "cross" button in dropdowna!localVariables( local!i18nInterfaceData: rule!INZ_I18N_loadBundlesFromFolder( bundleFolder: cons!INZ_CONS_INTERFACE_COMPONENT_INTERNATIONALIZATION_FILES ), a!recordFilterList( name: rule!INZ_I18N_displayLabel( i18nData: local!i18nInterfaceData, bundleKey: cons!INZ_CONS_TXT_INTERFACE_COMPONENT_INTERNATIONALIZATION & ".amendment" ), options: a!localVariables( local!fieldValues: rule!UWG_QR_fetchAmendmentMas

Is there a way to find all appian objects and its dependencies in a appian application  and export into excel so I can do analysis well before starting development with a team of 10 appian developers. We are at 24.3 version.