DESCRIPTION - Allows an authenticated user to retrieve all asset data (id, code, type, description, duration, media, marks, parental rate, episode number, synopsis, quality, etc.) of assets with at least one field partially/completely matching a given keyword. Please refer to the Etere tables > Assets repository chapter for information on fields returned by this function.
It's worth mentioning that the given keyword is searched across the following asset properties: assets (filmati), season (season), artists (artisti), genres (generi), interruptions (interruzioni), metadata (smpte), roles (ruoli), segments (mam),documents (doma) and subtitles (sottotitoli).
INPUT
Parameter - _user
Description: Login name of the executor.
Example: user01
Parameter - _pwd
Description: Password of the executor.
Example: pass01
Parameter - _searchString
Description: Keyword to be searched.
Example: oasis
Note: The full-text search supports using the following wildcards on the _searchString keyword:
Apple - Match fields containing the entire word apple
Apple or banana - Match fields containing at least one between the entire words apple and banana
Apple and banana - Match fields containing both entire words, apple and banana
NB: If two words are entered without operators (e.g. apple banana), the AND operator will be considered present (e.g. apple AND banana).
apple and not banana - Match fields containing only the entire word apple, not the word banana
" apple* " - Match fields containing a word starting by apple (e.g. apple, the apples, Appleton)
NB: The asterisk (*) must be preceded by at least one character (e.g. a).
"apple banana" - Match fields containing the exact phrase apple banana (e.g. apple banana juice)
apple near banana - Match fields containing the entire word apple, rating the result lower if it also contains the word banana.
*** - Match all assets in the database
NB: The three asterisks (***) must be entered without other characters.
OUTPUT - <f ID_FILMATI="1" COD_PROGRA="1" TIPO="T" DESCRIZIO="Wonderwall" DURATA="5884" POS_INI="125" POS_FIN="6008" INF_DIGIT="0" NEWTYPE="CLIP" ANNO_P="0" CONTROL_CODE="0" DATA_PROD="1994-12-01T00:00:00" NOTE_COMM="[Crawl]
LogoEffect=leCustom
[Titler]
Inizio=1
[Dsk1]
Inizio=1
[Evento]
Icona=TYPE_T
" NOTE_AMM="" PERC_AUTOP="0.0" ID_PROG_RIFERI="0" DUR_FISICA="6009" DESCRIZIO_1="Oasis - Wonderwall (Live at MTV Unplugged 1996)." DESCRIZIO_2="testing EPG of wonderwall !!" PARENT_RATE="G" PRODUZIONE="" PUNTATA="1" DATA_DIGIT="2012-06-14T10:58:57.573" DATA_ARRIVO="2010-07-04T00:00:00" COMUN_GRAT="0" COMUN_PREV="0" DURATA_PUB="5250" DATA_SCAD="2012-12-31T00:00:00" DATA_INIZIO_VALIDITA="2008-01-01T00:00:00" COPIA_ANAL="" COPIA_DIGI="" TRASCODING_FLAG="" INFO_PROGR="" BITRATE="0" DATA_MISU="1900-01-01T00:00:00" EXPORT="0" OPERATORE="sa@" QUALITA="0" DATA_QUALITA="2012-06-07T17:42:59.217" TIPO_TC="C" ASPECT="4" SPLITS="" NIELSEN="" PRIORITA="0" ID_PROG_COLLE="0" ROTAZIONE="0" LOC_NAZ="" MAGAZZINO="" ID_REGMASTER="12" CRYPTATO="" ID_FORNITORE="0" FILELQ="" STATUS_RC="" STATUS_MM="" SPONS_FROMBEGIN="S" SPONS_DUR="7500" SPONS_DES="" ID_SEASON="2983" ARCHIVIATO="" SOSPESO="" ANNULLATO="" BIANCONERO="" OPERATORE_REC="sa/EMANUELA" CLIP_SIZE="0" EXTERNALID="0" LASTUPDATE="2012-06-28T15:01:59.897" INF_LQ="502" CTL_LQ="-59" FLAGS="BC" PROD_INDIPENDENTE="0" INTRO="0" OUTRO="0" FADEIN="0" FADEOUT="0" JINGLEIN="0" BPM="113" TEMPO_INT="0" OPENER="1" VOCE="MAN" MESI="" SETT="" CLOCK="" LINGUA="eng" FLAG_NON_UDENTI="1" ID_TRAFFICDEPRECIATION="0" ORDER_REFERENCE="AO-CUY0081" ID_VIRTUALDOCUMENT="11" SCH_MONTHS="" SCH_DAYS="" SCH_HOURS="" AUDIO="SESE" AUDIO_LANGUAGE=" X X" ID_PROMOSOURCE="0" CAD_APPROVAL="CAD00056" SCHEDULE_CHECKSUM="833817202" RECFLAG="5" ID_ASPECTRATIOCONV="1" VIRTUAL="0" ID_RESPONSABILE="0" NONTRASMISSIBILE="0" HIDDEN="0" VIDEOAPPROVAL="VA-00062" INSTALLATION="701" ENABLEDDAYS="1111111" CREATIONDATE="2009-03-31T09:52:22.137"/>
.
<f ID_FILMATI="26" COD_PROGRA="26" TIPO="T" DESCRIZIO="Falling down" ...
.
<f ID_FILMATI="30" COD_PROGRA="30" TIPO="T" DESCRIZIO="Don't go away" ...
XSD (XML Schema Definition)
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="WSApiResponse" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="WSApiResponse" msdata:IsDataSet="true" msdata:Locale="en-US">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Function">
<xs:complexType>
<xs:sequence>
<xs:element name="asset" minOccurs="0" maxOccurs="unbounded">
<xs:complexType>
<xs:attribute name="ID_FILMATI" type="xs:string" />
<xs:attribute name="COD_PROGRA" type="xs:string" />
<xs:attribute name="TIPO" type="xs:string" />
<xs:attribute name="DESCRIZIO" type="xs:string" />
<xs:attribute name="DURATA" type="xs:string" />
<xs:attribute name="_x0040_dmw_x0023_supportod" type="xs:string" />
<xs:attribute name="_x0040_dmw_x0023_supportodbkp" type="xs:string" />
<xs:attribute name="POS_INI" type="xs:string" />
<xs:attribute name="POS_FIN" type="xs:string" />
<xs:attribute name="INF_DIGIT" type="xs:string" />
<xs:attribute name="NEWTYPE" type="xs:string" />
<xs:attribute name="ANNO_P" type="xs:string" />
<xs:attribute name="CONTROL_CODE" type="xs:string" />
<xs:attribute name="NOTE_COMM" type="xs:string" />
<xs:attribute name="NOTE_AMM" type="xs:string" />
<xs:attribute name="PERC_AUTOP" type="xs:string" />
<xs:attribute name="ID_PROG_RIFERI" type="xs:string" />
<xs:attribute name="DUR_FISICA" type="xs:string" />
<xs:attribute name="DESCRIZIO_1" type="xs:string" />
<xs:attribute name="DESCRIZIO_2" type="xs:string" />
<xs:attribute name="PARENT_RATE" type="xs:string" />
<xs:attribute name="PRODUZIONE" type="xs:string" />
<xs:attribute name="PUNTATA" type="xs:string" />
<xs:attribute name="TRAMA" type="xs:string" />
<xs:attribute name="DATA_DIGIT" type="xs:string" />
<xs:attribute name="DATA_ARRIVO" type="xs:string" />
<xs:attribute name="COMUN_GRAT" type="xs:string" />
<xs:attribute name="COMUN_PREV" type="xs:string" />
<xs:attribute name="DURATA_PUB" type="xs:string" />
<xs:attribute name="COPIA_ANAL" type="xs:string" />
<xs:attribute name="COPIA_DIGI" type="xs:string" />
<xs:attribute name="TRASCODING_FLAG" type="xs:string" />
<xs:attribute name="INFO_PROGR" type="xs:string" />
<xs:attribute name="BITRATE" type="xs:string" />
<xs:attribute name="DATA_MISU" type="xs:string" />
<xs:attribute name="EXPORT" type="xs:string" />
<xs:attribute name="OPERATORE" type="xs:string" />
<xs:attribute name="QUALITA" type="xs:string" />
<xs:attribute name="TIPO_TC" type="xs:string" />
<xs:attribute name="ASPECT" type="xs:string" />
<xs:attribute name="SPLITS" type="xs:string" />
<xs:attribute name="NIELSEN" type="xs:string" />
<xs:attribute name="PRIORITA" type="xs:string" />
<xs:attribute name="ID_PROG_COLLE" type="xs:string" />
<xs:attribute name="ROTAZIONE" type="xs:string" />
<xs:attribute name="LOC_NAZ" type="xs:string" />
<xs:attribute name="MAGAZZINO" type="xs:string" />
<xs:attribute name="ID_REGMASTER" type="xs:string" />
<xs:attribute name="CRYPTATO" type="xs:string" />
<xs:attribute name="ID_FORNITORE" type="xs:string" />
<xs:attribute name="FILELQ" type="xs:string" />
<xs:attribute name="_x0040_dmw_x0023_archivemain" type="xs:string" />
<xs:attribute name="_x0040_dmw_x0023_archivebkp" type="xs:string" />
<xs:attribute name="_x0040_dmw_x0023_archivelq" type="xs:string" />
<xs:attribute name="STATUS_RC" type="xs:string" />
<xs:attribute name="STATUS_MM" type="xs:string" />
<xs:attribute name="SPONS_FROMBEGIN" type="xs:string" />
<xs:attribute name="SPONS_DUR" type="xs:string" />
<xs:attribute name="SPONS_DES" type="xs:string" />
<xs:attribute name="ID_SEASON" type="xs:string" />
<xs:attribute name="ARCHIVIATO" type="xs:string" />
<xs:attribute name="SOSPESO" type="xs:string" />
<xs:attribute name="ANNULLATO" type="xs:string" />
<xs:attribute name="BIANCONERO" type="xs:string" />
<xs:attribute name="NOTE_A" type="xs:string" />
<xs:attribute name="NOTE_B" type="xs:string" />
<xs:attribute name="NOTE_C" type="xs:string" />
<xs:attribute name="OPERATORE_REC" type="xs:string" />
<xs:attribute name="CLIP_SIZE" type="xs:string" />
<xs:attribute name="EXTERNALID" type="xs:string" />
<xs:attribute name="LASTUPDATE" type="xs:string" />
<xs:attribute name="INF_LQ" type="xs:string" />
<xs:attribute name="CTL_LQ" type="xs:string" />
<xs:attribute name="FLAGS" type="xs:string" />
<xs:attribute name="PROD_INDIPENDENTE" type="xs:string" />
<xs:attribute name="INTRO" type="xs:string" />
<xs:attribute name="OUTRO" type="xs:string" />
<xs:attribute name="FADEIN" type="xs:string" />
<xs:attribute name="FADEOUT" type="xs:string" />
<xs:attribute name="JINGLEIN" type="xs:string" />
<xs:attribute name="BPM" type="xs:string" />
<xs:attribute name="TEMPO_INT" type="xs:string" />
<xs:attribute name="OPENER" type="xs:string" />
<xs:attribute name="VOCE" type="xs:string" />
<xs:attribute name="MESI" type="xs:string" />
<xs:attribute name="SETT" type="xs:string" />
<xs:attribute name="CLOCK" type="xs:string" />
<xs:attribute name="LINGUA" type="xs:string" />
<xs:attribute name="FLAG_NON_UDENTI" type="xs:string" />
<xs:attribute name="ID_TRAFFICDEPRECIATION" type="xs:string" />
<xs:attribute name="ORDER_REFERENCE" type="xs:string" />
<xs:attribute name="ID_VIRTUALDOCUMENT" type="xs:string" />
<xs:attribute name="SCH_MONTHS" type="xs:string" />
<xs:attribute name="SCH_DAYS" type="xs:string" />
<xs:attribute name="SCH_HOURS" type="xs:string" />
<xs:attribute name="ID_PROMOSOURCE" type="xs:string" />
<xs:attribute name="CAD_APPROVAL" type="xs:string" />
<xs:attribute name="SCHEDULE_CHECKSUM" type="xs:string" />
<xs:attribute name="RECFLAG" type="xs:string" />
<xs:attribute name="ID_ASPECTRATIOCONV" type="xs:string" />
<xs:attribute name="VIRTUAL" type="xs:string" />
<xs:attribute name="ID_RESPONSABILE" type="xs:string" />
<xs:attribute name="NONTRASMISSIBILE" type="xs:string" />
<xs:attribute name="HIDDEN" type="xs:string" />
<xs:attribute name="VIDEOAPPROVAL" type="xs:string" />
<xs:attribute name="INSTALLATION" type="xs:string" />
<xs:attribute name="ENABLEDDAYS" type="xs:string" />
<xs:attribute name="CREATIONDATE" type="xs:string" />
<xs:attribute name="VERSION" type="xs:string" />
<xs:attribute name="READONLY" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="Name" type="xs:string" />
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>