Records

Can I create Service-Backed_Record with POST API which returns data on input parameter, How differently it works from GET API. What could be the possible I may face if I use POST API for Service-Backed_Record.

Muy buenos dias  estoy realizando el curos de APPIAN y el comunity no me esta dejando crear nuevos recorda Type ya no aparece esta opcion como antes en la imagen adjunta les muesto como apareceia antes y como esta apareciendo ahora  Alguien me podria ayudar por favor ?  quedo super atenta 

HI. I attempted to do a rather large import of an application over our PP environments version. I looked over a record that had some Record Related Action name changes to it. Testing it afterwards, only half of the related action name updates took on import.  I confirmed the record was modified on import. Has anyone ever had this happen before?  I have no way to deploy proper changes due to this.

Yesterday I created a record from a Record Type list action. I can see the record in the database and when I open the Record Type View I see the record as well. My doubt is why I can see the record if the last sync was last month. As far a I know, when you use a Record Type it is necessary to sync the data. Is there any way you can configure an automatic sync or sometrhing like that? Thanks.

Please suggest  how can we calculate years given by days using record types

We have two separate databases: a legacy one (Oracle) and a current one (MariaDB). We do not want to import the legacy data into the current database. However, our customer wants to be able to search records across both databases. The requirement is to connect both databases to our current application and build a search interface on a single page. There is no relationship between the two databases; the cases exist independently in each database and need to be merged for the search. Is there a way to connect both schemas and build a unified search interface? How can we solve this problem using Appian?

Hi, I have a 2 record with one to many relationship. I am trying to write the parent and the related records. The child record will have multiple values . Each value should get inserted in different rows. When I tried foreach loop for the related record it is storing all  the values in the same row of child record. Please help me with this

Created new record type for subscriber Added relationship with base record type Eventhistory eventType event thread configured. flowed below steps  On the base record type, edit the record events configuration: Go to Events. Click EDIT. Configure the following Subscriber properties: there is no option to add subscriber record and unable to see the subscriber icon on event history in summary view  anyone implemented please post your suggestion  @Everyone  we upgraded now to 25.1.  while enabling subscriber am facing issue a!eventHistoryListField [line 736]: Unable to write to or delete from the source due to a data integrity violation. Error Details: Field 'ID' doesn't have a default value anyone faced the same issue, any suggestions or inputs helpful thanks in advance   

I have a process that needs to store entities and alerts in different tables. Flow of the process: First, I need to save the entity using the Write Record Smart Service. After the entity is saved, I need to get the ID of the created entity. Using this ID, I will then save the corresponding alert with another Write Record Smart Service. Question: Is there a way to get the ID of the newly created entity directly from the Write Record Smart Service, without having to perform an additional query from the record or database? Here is the example of process:

Hi all, I'm a bit new with custom record fields, so I'm probably doing something wrong. I have header and detail records (with a one-to-many relationship connected with a detail reference to the header key), and that data flows throughout the system just fine.  But I added a real-time aggregation / sum custom field (for totaling amounts in the detail record for presentation) and am having trouble getting data into the new fields. When pressing the 'Test' button in the Edit Custom Record Field screen, I see data grouped and summed as needed which is great! After saving the new custom field, the 'Data Preview' test button does NOT return any data in the new field, and that is also the case with an interface that references this. I've done resync on both records.  The new custom field exists on the detail side of the relationship and when defining the field, I use the format: headerRec.detailRec.amountToBeSummed. I've a

Hello, We need to export data from a database based on user-selected filters into an Excel sheet for reporting. Currently, our process queries data in batches of 500 rows and uses the deprecated "Export CDT to Excel" function to generate the report, as we need to export 80 columns. Since we are running in batches, we cannot keep the smart service into separate start process as we are appending the generated document with new values and incrementing the start index.  However, as the data volume has increased, users are exporting data upto 50,000 rows, leading to memory heap issues causing Appian server to go down. The latest export functions have a limitation of 50 columns, which does not meet our requirements. We made process variables as hidden but still memory is hitting upto 6k AMU. We are using mySQL as database which is hosted on AWS RDS. Currently we are using a!executeStoredProcedureForQuery() to query the data from database. Before we wer

So, I'm building a record where i have all the items in the store, then i can drill down to 1 item and update ir, but when i click on update item related action i get this error:  An error occurred while applying the context for the AS Items In Store related action [identifier=21]. Details: No process parameter found corresponding to override [name=pv!item]. Non-parameter process variables cannot be overridden. Any help?

Hi, I'm just getting started with learning Appian. Was trying to create a recordtype from scratch with v25.1 community edition. But, dont see an option to do so Can someone please help?

Hi team,Scenario - There are many table for our application and all of these tables have there respective Appian records. Now, if someone adds unique key constraint to any of the column on any table then we also need to re-map column on the respective records. Ask - Is there any direct way to generate a summary report to fetch all the records whose mapping of columns is breaking/ where we need to remap the columns in our record.

I want to add searchable filters in a recordtype, is there anyway to achieve this? For example, i have made a custom filter below which calls DB & gets the productionUnitCode upto 15 & then i can select multiple in it. I want same thing with record filter rather than custom making it.

hi, I was wondering if I can export data in process model  with expression rule? Data from expression rule: List of Dictionary - 2 items    Dictionary           name "John"(Text)           memberID"X123"(Text)    Dictionary         name "Jane"(Text)         memberID"X456"(Text) Export the below data to csv or txt file( without any header) John, X123 Jane, X456

Hello Appian Community, I've been given a somewhat complex JSON format to ingest into Appian and stage all the data into the DB.  The intention of the data is for reference/comparison/reporting.  I've tested the regular readtextfromfile/fromJson/jsonPath functions to grab each attribute but it feels very tedious/clunky to have an JSON path expression for ever attribute I need.  Could I get any advice on a more efficient way to parse this data and get it in the DB? Data Context: One JSON will have thousands of "FullProduct" entities so I will be dealing with files with a size of at most 25MB.  This structure is the final format so there is no altering the original file. JSON Sample: { "FULLPRODUCTFILE": [ { "FullProduct": { "ID": "*dfg333", "Details": { "StatusType": "LIVE", "Status": "ACTIVE" }, "Classification": [

I have a View in the Appian Cloud database with a column that concatenates some values, lets call it column "CODES". I started in our dev environments creating a CDT from Table/View and verifying the datastore. I then did a distribution to the test environment of the CDT, View and Datastore. While verifying in test environment I get an error that CODES is not a MEDIUMTEXT, it's a LONGTEXT. Not knowing what to do I try to create the CDT in test environment and actually the generated CDT in this environment is different that the one that was generated in dev, even though the database view is the same. Any suggestions on how to solve this issue? The thing is that I don't know in a production environment which datatype Appian will choose, and I don't want to create objects manually in production, I shouldn't even be able to. Thank you!

I want to generate a table inside a word doc, below is the config of the smart service "Text Doc from Template": 

I need to make a record-like query for a 1 to N relationship, in which it only returns the values ​​of the parent record if all the values ​​in the N relationship meet a condition. Example : I have a record called "Need" and it is related to another called "needchangestate" through a relationship 1 to N, I need it to return only the needs where all the needchangestate meet a condition, if all the elements of the relationship N do not meet the condition, the element Need should not appear Currently it returns me an investment where the condition is met in at least one of the records of the relationship N but this is not what I am looking for.

I need to deploy a series of datatypes to another environment. So I deployed the datatypes and then the datastore, and overwrote the original. Now the datatypes I needed are on the new datastore.But when I go on with the deployment sending the rest of the changes to my environment, the Data store entities constants related to the datatypes I recently sent to my other environment give me the following error: UnresolvedDataStoreEntityException: entity [...] in data store [id=... uuid=...] cannot be found.help, please!

Hi, I need help understanding why record sync is not occurring when using the "Write to Datastore" smart service in one environment, while the latest data appears in the records in another environment. In the environment where sync is not happening, a manual sync is required to view the latest data. Can someone help me understand the cause of this issue?

Hi, I'm using Appian 24.2.270.0 and trying to insert an eventHistoryListField with comments in an interface , but when I click in the field for comments, the buttons appears like in the image here below.By clicking, the comment is inserted fine but why those buttons?Any solution?Thanks!

I want to change the field name of a CDT to match the renamed field in the database. The old name was "FIRSTNAME" and the new one is "FIRST_NAME". Related to the best practices, the best way to do so is to download the CDT as XSD, change the field name in there, and re-upload the XSD, verify and publish the data store as a last step or is there any other best practice thing? Thanks in advance.

Can I add hidden record fields if data sync is NOT enabled on a record type?