Web Service Data Source
Joaquin asked 4 years ago
Hi, i´ll try to explain my problem.
i´m Trying to use BANXICO web service to integrate the USD and EUR exchange rate to Dynamics GP every day,
the response of the web service is like this:
<?xml version=”1.0″ encoding=”ISO-8859-1″?>
-<CompactData xsi:schemaLocation=”http://www.SDMX.org/resources/SDMXML/schemas/v1_0/message SDMXMessage.xsd http://www.banxico.org.mx/structure/key_families/dgie/sie/series/compact BANXICO_DGIE_SIE_Compact.xsd http://www.SDMX.org/resources/SDMXML/schemas/v1_0/compact SDMXCompactData.xsd” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:compact=”http://www.SDMX.org/resources/SDMXML/schemas/v1_0/compact” xmlns:bm=”http://www.banxico.org.mx/structure/key_families/dgie/sie/series/compact” xmlns=”http://www.SDMX.org/resources/SDMXML/schemas/v1_0/message”>
-<Header>
<ID>TIPOSDECAMBIO</ID>
<Test>false</Test>
<Truncated>false</Truncated>
<Name xml:lang=”sp”>Tipos de Cambio</Name>
<Prepared>2019-05-24 00:00:07.740</Prepared>
-<Sender id=”BANXICO”>
<Name xml:lang=”sp”>Banco de México</Name>
+<Contact>
</Sender>
<DataSetAction>Update</DataSetAction>
<Extracted>2019-05-24 00:00:07.740</Extracted>
</Header>
-<bm:DataSet>
<bm:SiblingGroup TIME_FORMAT=”P1D” BANXICO_FREQ=”Dia”/>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”Peso” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF46410″ TITULO=”Cotización de las divisas que conforman la canasta del DEG Respecto al peso mexicano Euro”>
<bm:Obs OBS_VALUE=”21.171″ TIME_PERIOD=”2019-05-23″/>
</bm:Series>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”Peso” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF60632″ TITULO=”Cotización de la divisa Respecto al peso mexicano Dólar Canadiense”>
<bm:Obs OBS_VALUE=”14.1303″ TIME_PERIOD=”2019-05-23″/>
</bm:Series>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”PesoxDoll” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF43718″ TITULO=”Tipo de cambio Pesos por dólar E.U.A. Tipo de cambio para solventar obligaciones denominadas en moneda extranjera Fecha de determinación (FIX)”>
<bm:Obs OBS_VALUE=”19.0122″ TIME_PERIOD=”2019-05-23″/>
</bm:Series>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”Peso” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF46407″ TITULO=”Cotización de las divisas que conforman la canasta del DEG Respecto al peso mexicano Libra esterlina”>
<bm:Obs OBS_VALUE=”24.0428″ TIME_PERIOD=”2019-05-23″/>
</bm:Series>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”Peso” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF46406″ TITULO=”Cotización de las divisas que conforman la canasta del DEG Respecto al peso mexicano Yen japonés”>
<bm:Obs OBS_VALUE=”0.1727″ TIME_PERIOD=”2019-05-23″/>
</bm:Series>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”PesoxDoll” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF60653″ TITULO=”Tipo de cambio pesos por dólar E.U.A. Tipo de cambio para solventar obligaciones denominadas en moneda extranjera Fecha de liquidación”>
<bm:Obs OBS_VALUE=”18.9755″ TIME_PERIOD=”2019-05-24″/>
</bm:Series>
</bm:DataSet>
</CompactData>
my problem is: all nodes inside <bm:DataSet> doesnt appears on the data set.
how can i get the data to map it ?
i´m Trying to use BANXICO web service to integrate the USD and EUR exchange rate to Dynamics GP every day,
the response of the web service is like this:
<?xml version=”1.0″ encoding=”ISO-8859-1″?>
-<CompactData xsi:schemaLocation=”http://www.SDMX.org/resources/SDMXML/schemas/v1_0/message SDMXMessage.xsd http://www.banxico.org.mx/structure/key_families/dgie/sie/series/compact BANXICO_DGIE_SIE_Compact.xsd http://www.SDMX.org/resources/SDMXML/schemas/v1_0/compact SDMXCompactData.xsd” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:compact=”http://www.SDMX.org/resources/SDMXML/schemas/v1_0/compact” xmlns:bm=”http://www.banxico.org.mx/structure/key_families/dgie/sie/series/compact” xmlns=”http://www.SDMX.org/resources/SDMXML/schemas/v1_0/message”>
-<Header>
<ID>TIPOSDECAMBIO</ID>
<Test>false</Test>
<Truncated>false</Truncated>
<Name xml:lang=”sp”>Tipos de Cambio</Name>
<Prepared>2019-05-24 00:00:07.740</Prepared>
-<Sender id=”BANXICO”>
<Name xml:lang=”sp”>Banco de México</Name>
+<Contact>
</Sender>
<DataSetAction>Update</DataSetAction>
<Extracted>2019-05-24 00:00:07.740</Extracted>
</Header>
-<bm:DataSet>
<bm:SiblingGroup TIME_FORMAT=”P1D” BANXICO_FREQ=”Dia”/>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”Peso” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF46410″ TITULO=”Cotización de las divisas que conforman la canasta del DEG Respecto al peso mexicano Euro”>
<bm:Obs OBS_VALUE=”21.171″ TIME_PERIOD=”2019-05-23″/>
</bm:Series>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”Peso” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF60632″ TITULO=”Cotización de la divisa Respecto al peso mexicano Dólar Canadiense”>
<bm:Obs OBS_VALUE=”14.1303″ TIME_PERIOD=”2019-05-23″/>
</bm:Series>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”PesoxDoll” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF43718″ TITULO=”Tipo de cambio Pesos por dólar E.U.A. Tipo de cambio para solventar obligaciones denominadas en moneda extranjera Fecha de determinación (FIX)”>
<bm:Obs OBS_VALUE=”19.0122″ TIME_PERIOD=”2019-05-23″/>
</bm:Series>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”Peso” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF46407″ TITULO=”Cotización de las divisas que conforman la canasta del DEG Respecto al peso mexicano Libra esterlina”>
<bm:Obs OBS_VALUE=”24.0428″ TIME_PERIOD=”2019-05-23″/>
</bm:Series>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”Peso” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF46406″ TITULO=”Cotización de las divisas que conforman la canasta del DEG Respecto al peso mexicano Yen japonés”>
<bm:Obs OBS_VALUE=”0.1727″ TIME_PERIOD=”2019-05-23″/>
</bm:Series>
-<bm:Series BANXICO_FREQ=”Dia” BANXICO_UNIT_TYPE=”PesoxDoll” BANXICO_FIGURE_TYPE=”TipoCambio” IDSERIE=”SF60653″ TITULO=”Tipo de cambio pesos por dólar E.U.A. Tipo de cambio para solventar obligaciones denominadas en moneda extranjera Fecha de liquidación”>
<bm:Obs OBS_VALUE=”18.9755″ TIME_PERIOD=”2019-05-24″/>
</bm:Series>
</bm:DataSet>
</CompactData>
my problem is: all nodes inside <bm:DataSet> doesnt appears on the data set.
how can i get the data to map it ?
Answers
Ethan Sorenson Staff answered 4 years ago
Joaquin,
How are you using SmartConnect to connect to the service? The REST Connector, web service connector, XML query? these would require different configuration steps.
REST Connector: You will need to edit your ‘Return Type’ to specify the data with the correct name, and type. If you are having issues, start with one field, and slowly add fields until you find the one causing issues.
Web Service Connector: This is all specified based on the provided WSDL. I do not believe there is a way to manipulate further than this.
XML Query: If you download the XML file from BANXICO to a folder on the local machine, and read it from there, this would be the easiest way to manipulate and read the file, because you can use XSL sheet to edit the query. This can be especially useful when the file is using custom schemas like the one provided here.
How are you using SmartConnect to connect to the service? The REST Connector, web service connector, XML query? these would require different configuration steps.
REST Connector: You will need to edit your ‘Return Type’ to specify the data with the correct name, and type. If you are having issues, start with one field, and slowly add fields until you find the one causing issues.
Web Service Connector: This is all specified based on the provided WSDL. I do not believe there is a way to manipulate further than this.
XML Query: If you download the XML file from BANXICO to a folder on the local machine, and read it from there, this would be the easiest way to manipulate and read the file, because you can use XSL sheet to edit the query. This can be especially useful when the file is using custom schemas like the one provided here.