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 all assets with at least one field partially/completely matching a given keyword.
Please note that the given keyword is searched across the following asset properties (i.e. Etere tables): assets (film) and season (season):
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: charlie b*
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 complete words apple and banana
Apple and banana - Match fields containing both complete 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 an expression starting with 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 includes the banana.
*** - Match all assets in the database
NB: The three asterisks (***) must be entered without other characters.
OUTPUT - <asset ID_FILMATI="9" COD_PROGRA="Charlie Brown-0001" TIPO="T" DESCRIZIO="Charlie Brown - No.0001" DURATA="45000" _x0040_dmw_x0023_supportod="" _x0040_dmw_x0023_supportodbkp="" POS_INI="0" POS_FIN="44999" INF_DIGIT="0" NEWTYPE="TV" ANNO_P="0" CONTROL_CODE="0" DATA_PROD="1960-12-25T00:00:00" NOTE_COMM="" NOTE_AMM="" PERC_AUTOP="0.0" ID_PROG_RIFERI="0" DUR_FISICA="45000" DESCRIZIO_1="" DESCRIZIO_2="" PARENT_RATE="0" PRODUZIONE="" PUNTATA="1" TRAMA="" COMUN_GRAT="0" COMUN_PREV="0" DURATA_PUB="45000" COPIA_ANAL="" COPIA_DIGI="" TRASCODING_FLAG="" INFO_PROGR="" BITRATE="0" DATA_MISU="1900-01-01T00:00:00" EXPORT="0" OPERATORE="" QUALITA="0" TIPO_TC="C" ASPECT="4" SPLITS="" NIELSEN="" PRIORITA="0" ID_PROG_COLLE="0" ROTAZIONE="0" LOC_NAZ="" MAGAZZINO="" ID_REGMASTER="0" CRYPTATO="" ID_FORNITORE="3" FILELQ="" _x0040_dmw_x0023_archivemain="" _x0040_dmw_x0023_archivebkp="" _x0040_dmw_x0023_archivelq="" STATUS_RC="" STATUS_MM="" SPONS_FROMBEGIN="S" SPONS_DUR="0" SPONS_DES="" ID_SEASON="9" ARCHIVIATO="" SOSPESO="" ANNULLATO="" BIANCONERO="" NOTE_A="" NOTE_B="" NOTE_C="" OPERATORE_REC="" CLIP_SIZE="0" EXTERNALID="0" LASTUPDATE="2009-04-09T12:17:47.007" INF_LQ="0" CTL_LQ="0" FLAGS="" PROD_INDIPENDENTE="0" INTRO="0" OUTRO="0" FADEIN="0" FADEOUT="0" JINGLEIN="0" BPM="0" TEMPO_INT="0" OPENER="0" VOCE="" MESI="" SETT="" CLOCK="" LINGUA="" FLAG_NON_UDENTI="0" ID_TRAFFICDEPRECIATION="0" ORDER_REFERENCE="" ID_VIRTUALDOCUMENT="0" SCH_MONTHS="" SCH_DAYS="" SCH_HOURS="" AUDIO="L" AUDIO_LANGUAGE=" " ID_PROMOSOURCE="0" CAD_APPROVAL="" SCHEDULE_CHECKSUM="-1345911616" RECFLAG="0" ID_ASPECTRATIOCONV="0" VIRTUAL="0" ID_RESPONSABILE="1" NONTRASMISSIBILE="0"/>
<asset ID_FILMATI="9" COD_PROGRA="Charlie Brown-0002" TIPO="T" DESCRIZIO="Charlie Brown - No.0002" ...
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>