We have a requirement to pull Service backed records which needs some query parameter to it only pulls Records based on user selection.
I was not able to find a way to pass parameter to the recordtype , is there a way to do that ?
rule!myIntegrationPointingToServiceBackRecords
(
input1: ri!input,
batchnumber: ri!batchnumber
)
Discussion posts and replies are publicly visible
Is the Record available in the environment or are you looking to configure the Record itself?
If the Record is already available and has pulled data from the data source, then you can just use the Query Record functionality.
https://docs.appian.com/suite/help/25.1/query-editor.html#query-records
If the Record Type does not exist, and you need to configure it, then follow the guide here ...
https://docs.appian.com/suite/help/25.1/configure-record-data-source.html#create-a-record-data-source
Reference: . Example : https://docs.appian.com/suite/help/24.1/Service-Backed_Record_Tutorial.html Look for SpaceX_getFilteredLaunches_recordDataSource
Here is what I want to achieve -
1. I want to create a readonly grid using recordtype (e.g.A recortype that points to SpaceX_getFilteredLaunches_recordDataSource)
2. The data for this grid should come from a record type data source (service backed e.g. ), the record datasource has rule input parameters for filters (check SpaceX_getFilteredLaunches_recordDataSource)
3. The grid needs to pass initial parameters to the recordtype data in the grid so it is filtered and not bring in all data
4. The question is how do i pass the parameters to the record type data source from the grid
5. Example : https://docs.appian.com/suite/help/24.1/Service-Backed_Record_Tutorial.html Look for SpaceX_getFilteredLaunches
You can't pass it to the Record Type but you can just add filters to the queryRecordType, no?
docs.appian.com/.../Query_Recipes.html
The webservice endpoint needs parameters passed , I am not sure if the recordtype will pull all the data if the datasource is not a filtered datasource and then does the queryfilter runs on top of the pulled records OR the queryfilter will translate to query parameter of the webservice endpoint ? If its not the latter the performance will be an issue as the payload is going to be large .. which is why using filteredDataource is would make more sense. But if we define a recordType using the filtered dataource , how do we pass the input parameters when creating this type of recordtype? When i tried to create a recordtype using filtered datasource, it defaults to 'unsynced' which doesn't support filters in a!queryrecordtype (Record types sourced from a web service or other expression only support filter parameter if the data is synced). Also if i use the filtered datasource for the data in the grid, it doesn't support search and user filters .. lot of constraints
A synched Record does not support dynamic parameters on sync. You need to sync all the data and then you can filter by user by running queries on it. If that is not possible, I would suggest you just call the integration directly.