Skip to main content
May 19, 2025
Question

Service backed records passing parameters - Filtered

  • May 19, 2025
  • 5 replies
  • 0 views

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

)

5 replies

May 19, 2025

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

ravib0008Author
May 20, 2025

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

mathieud0001
May 21, 2025

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

ravib0008Author
May 22, 2025

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

mathieud0001
May 22, 2025

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.