...
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
Basically, all Text and Choice schema elements for the display of an Object are used comma-separated in the search result list or in the selection list.
However, if you want to display only certain fields in the list view, you can configure the displayed fields via Summary:
...
Name | Description | Link |
|---|---|---|
| Access to .csv files | |
| Access to Excel files | |
| Access to HTTP/HTTPs APIs (REST/Web APIs) | |
| Access to SQL databases |
Example
| Code Block | ||
|---|---|---|
| ||
<ObjectCollection Id="RecipientAddressData" Label="Recipient addresses">
<Schema>
<Text Id="CompanyName" Label="Company name" />
<Text Id="Street" Label="Street" />
<Text Id="PostalCode" Label="Zip" />
<Text Id="City" Label="City" />
<Text Id="Country" Label="Country" />
</Schema>
<Summary>
<Field Id="CompanyName" />
<Field Id="City" />
</Summary>
<DataProviders>
<CsvDataProvider DisplayName="Customer addresses">
<Options>
<FilePath>\\fileshare\addressdata.csv</FilePath>
<HasHeaders>true</HasHeaders>
<Delimiter>,</Delimiter>
</Options>
<SearchParameters>
<Text Id="CompanyName" Label="Company name" />
<Text Id="Ort" Label="City" />
</SearchParameters>
<Mapping>
<Map Source="Firma" Target="CompanyName" />
<Map Source="Strasse" Target="Street" />
<Map Source="PLZ" Target="PostalCode" />
<Map Source="Ort" Target="City" />
<Map Source="Land" Target="Country" />
</Mapping>
</CsvDataProvider>
<HttpDataProvider DisplayName="TelSearch">
<SearchParameters>
<Text Id="What" Label="Search term" />
</SearchParameters>
<Configuration>
<Step>
<Request Method="Get">
<Url><![CDATA[https://tel.search.ch/api/?was={What}&key=[...]&maxnum=100]]></Url>
</Request>
<Response>
<Data XPath="*[local-name()='feed']/*[local-name()='entry']">
<Mapping>
<Map Source="*[local-name()='name']" Target="CompanyName" />
<Map Target="Street">
<Map.SourceExpression><![CDATA[
function main()
{
const street = source("*[local-name()='street']");
const streetno = source("*[local-name()='streetno']");
return street + " " + streetno;
}
]]></Map.SourceExpression>
</Map>
<Map Source="*[local-name()='zip']" Target="PostalCode" />
<Map Source="*[local-name()='city']" Target="City" />
<Map SourceValue="CH" Target="Country" />
</Mapping>
</Data>
</Response>
</Step>
</Configuration>
</HttpDataProvider>
</DataProviders>
</ObjectCollection> |
...