XML from Swagger can not open in SSRS

S. Lerner 41 Reputation points
2021-08-12T13:25:38.947+00:00

Hi

WebApi to Swagger from SSRS
returns XML
but SSRS can not open the XML - claims it's not well formed - but it is well formed !!!

Any ideas ??

Thanks

David

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,988 questions
0 comments No comments
{count} votes

Accepted answer
  1. Michael Taylor 56,856 Reputation points
    2021-08-12T14:14:10.157+00:00

    I find it peculiar that you'd be trying to "open" XML from Swagger in SSRS? More importantly SQL doesn't "open" XML so I'm not sure what you mean.

    In SQL you can store XML data as regular text using (N)VARCHAR. Since it is regular text SQL wouldn't try to do any interpretation.

    You can also store XML as XML in SQL. But again it is just raw text so I'm not sure where SQL would try to translate it. However when you query data you can use the XML-specific instructions in SQL to query data. In this case your query has to understand the XML structure otherwise it'll fail to read the XML. That doesn't mean the XML is invalid but rather your query is.

    As for SSRS it doesn't understand XML at all and would just see it as text. So you're back to the query you are using trying to do something with the XML. SSRS itself has no issues with queries extracting XML because it is just a reporting tool.

    Can you please provide more information about exactly what "opening" means, what XML is failing, what you're trying to do when it fails and what exact error(s) you're getting.

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. S. Lerner 41 Reputation points
    2021-08-16T05:01:09.067+00:00

    Hi

    Thanks for your reply

    I am using SSRS
    My DataSource is XML which is provided by swagger
    Swagger generates the following XML:

    <tns7:SpGetTsuotKupotOneHodOuput xmlns:tns2="http://xmlns.example.com/20210728153411PLT" xmlns:tns7="SpGetTsuotKupotOneHodOuput" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <GetTsuotKupotOneHodOuput>
    <ID>101</ID>
    <SHM>הראל אג"ח עד 25% מניות </SHM>
    <SHM_EDITED> *** הראל אג"ח עד 25% מניות </SHM_EDITED>
    <TKUFA>201909</TKUFA>
    <MITZ_TKUFA>0.59</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>6.82</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>10626.17</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>6269.4403</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-77.14</TZVIRA_NETO>
    <ALPHA>0.72</ALPHA>
    <SHARP_RELATIVE>-0.39</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.12</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>6.81635</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>0.59</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.72</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    </tns7:SpGetTsuotKupotOneHodOuput>

    However, when I try to Display the report I get the following error message:

    An error occured during local report processing.
    An error has occurred during report processing
    Data at the root level is invalid. Line 1, position 1.

    Which seems to infer problems with the XML file

    However,
    If I copy the XML into SSRS as follows:

    <Query>
    <XmlData>
    <tns7:SpGetTsuotKupotOneHodOuput xmlns:tns2="http://xmlns.example.com/20210728153411PLT" xmlns:tns7="SpGetTsuotKupotOneHodOuput" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <GetTsuotKupotOneHodOuput>
    <ID>101</ID>
    <SHM>הראל אג"ח עד 25% מניות </SHM>
    <SHM_EDITED> *** הראל אג"ח עד 25% מניות </SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>1.14</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>8.03</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>10630.92</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>12119.2488</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-107.21</TZVIRA_NETO>
    <ALPHA>0.84</ALPHA>
    <SHARP_RELATIVE>-0.37</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.22</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>103</ID>
    <SHM>מיטב דש גמל לבני 50-60</SHM>
    <SHM_EDITED> ** מיטב דש גמל לבני 50-60</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>1.11</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>9.68</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>7205.04</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>7997.5944</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-27.15</TZVIRA_NETO>
    <ALPHA>0.96</ALPHA>
    <SHARP_RELATIVE>0.18</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.12</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>107</ID>
    <SHM>הלמן-אלדובי גמל אג"ח עד 25% במניות</SHM>
    <SHM_EDITED> **הלמן-אלדובי גמל אג"ח עד 25% במניות</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>0.82</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>7.67</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>1006.15</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>825.043</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-12.82</TZVIRA_NETO>
    <ALPHA>0.6</ALPHA>
    <SHARP_RELATIVE>-0.62</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.2</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>117</ID>
    <SHM>כלל תמר אג"ח </SHM>
    <SHM_EDITED> ** כלל תמר אג"ח </SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>0.54</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>7.07</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>866.74</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>468.0396</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-5.36</TZVIRA_NETO>
    <ALPHA>-0.6</ALPHA>
    <SHARP_RELATIVE>-0.57</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.25</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>119</ID>
    <SHM>מנורה מבטחים יותר מסלול ד</SHM>
    <SHM_EDITED>מנורה מבטחים יותר מסלול ד</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>0.93</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>8.23</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>1058.21</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>984.1353</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>0.57</TZVIRA_NETO>
    <ALPHA>0.72</ALPHA>
    <SHARP_RELATIVE>-0.51</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.26</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>120</ID>
    <SHM>מיטב דש ביטחון מבטיח תשואה 4.5%</SHM>
    <SHM_EDITED>מיטב דש ביטחון מבטיח תשואה 4.5%</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA xsi:nil="true"/>
    <MITZ_MI_THILAT_SHANA xsi:nil="true"/>
    <YIT_NCHASIM_BFOAL>76.52</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>2</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>מבטיחת תשואה</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>0</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-0.3</TZVIRA_NETO>
    <ALPHA xsi:nil="true"/>
    <SHARP_RELATIVE xsi:nil="true"/>
    <SHARP_ABSOLUTE xsi:nil="true"/>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>124</ID>
    <SHM>כלל תמר מדד</SHM>
    <SHM_EDITED> **כלל תמר מדד</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>0.48</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>7.33</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>907.53</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>435.6144</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-7.66</TZVIRA_NETO>
    <ALPHA>-0.48</ALPHA>
    <SHARP_RELATIVE>-0.69</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.02</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>127</ID>
    <SHM>כלל תמר מניות</SHM>
    <SHM_EDITED> ** כלל תמר מניות</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>2.69</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>18.34</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>302</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>812.38</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>1.06</TZVIRA_NETO>
    <ALPHA>1.08</ALPHA>
    <SHARP_RELATIVE>0.54</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>0.78</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>128</ID>
    <SHM>כלל תמר שקלי טווח קצר</SHM>
    <SHM_EDITED> כלל תמר שקלי טווח קצר</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>0.02</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>0.42</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>148.18</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>2.9636</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-1.27</TZVIRA_NETO>
    <ALPHA>-0.12</ALPHA>
    <SHARP_RELATIVE>-1.16</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>-0.33</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>130</ID>
    <SHM>שובל</SHM>
    <SHM_EDITED> *
    ** שובל</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>1.09</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>8.95</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>81.58</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>88.9222</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>3</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-1.35</TZVIRA_NETO>
    <ALPHA>0.12</ALPHA>
    <SHARP_RELATIVE>-0.9</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>0.85</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>205</ID>
    <SHM>פסגות גדיש חו"ל</SHM>
    <SHM_EDITED>פסגות גדיש חו"ל</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>1.78</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>6.85</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>131.26</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>233.6428</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>0.54</TZVIRA_NETO>
    <ALPHA>-0.48</ALPHA>
    <SHARP_RELATIVE>-0.22</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>0.74</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>211</ID>
    <SHM>אקסלנס גמל אג"ח עד 15% מניות</SHM>
    <SHM_EDITED> *** אקסלנס גמל אג"ח עד 15% מניות</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>0.95</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>8.14</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>2143.89</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>2036.6955</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-5.49</TZVIRA_NETO>
    <ALPHA>0.24</ALPHA>
    <SHARP_RELATIVE>-0.5</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.39</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>223</ID>
    <SHM>מיטב דש גמל אג"ח ללא מניות</SHM>
    <SHM_EDITED> ** מיטב דש גמל אג"ח ללא מניות</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>0.43</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>6.31</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>793.71</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>341.2953</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-5.36</TZVIRA_NETO>
    <ALPHA>0.12</ALPHA>
    <SHARP_RELATIVE>-0.54</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.7</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>229</ID>
    <SHM>קופת התגמולים של עובדי בנק לאומי</SHM>
    <SHM_EDITED> **** קופת התגמולים של עובדי בנק לאומי</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>1.25</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>9.93</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>6792.02</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>8490.025</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>2</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-284.07</TZVIRA_NETO>
    <ALPHA>1.08</ALPHA>
    <SHARP_RELATIVE>0.27</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.08</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>253</ID>
    <SHM>כלל תמר אג"ח עד 25% מניות </SHM>
    <SHM_EDITED> ** כלל תמר אג"ח עד 25% מניות </SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>0.97</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>9.27</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>11661.23</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>11311.3931</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>4.79</TZVIRA_NETO>
    <ALPHA>0.96</ALPHA>
    <SHARP_RELATIVE>0.4</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.37</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>257</ID>
    <SHM>הלמן-אלדובי גמל ישראל</SHM>
    <SHM_EDITED> הלמן-אלדובי גמל ישראל</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>1.24</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>10.13</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>3114.61</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>3862.1164</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-14.67</TZVIRA_NETO>
    <ALPHA>0.96</ALPHA>
    <SHARP_RELATIVE>0.42</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.29</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>259</ID>
    <SHM>הלמן-אלדובי גמל כללי (לשעבר קופת פקידי מרכנתיל דיסקונט)</SHM>
    <SHM_EDITED> *
    הלמן-אלדובי גמל כללי (לשעבר קופת פקידי מרכנתיל דיסקונט)</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>0.97</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>8.91</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>195.62</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>189.7514</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-0.3</TZVIRA_NETO>
    <ALPHA>0.96</ALPHA>
    <SHARP_RELATIVE>-0.06</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.55</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>260</ID>
    <SHM>מנורה מבטחים אמיר כללי</SHM>
    <SHM_EDITED>מנורה מבטחים אמיר כללי</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>1.22</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>10.12</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>547.39</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>667.8158</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-2.29</TZVIRA_NETO>
    <ALPHA>0.72</ALPHA>
    <SHARP_RELATIVE>0.42</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.12</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>263</ID>
    <SHM>בר</SHM>
    <SHM_EDITED>בר</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>1.37</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>10.49</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>4068.74</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>5574.1738</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-8.99</TZVIRA_NETO>
    <ALPHA>0.96</ALPHA>
    <SHARP_RELATIVE>0.83</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.16</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>270</ID>
    <SHM>פסגות גדיש אגח עד 20% מניות</SHM>
    <SHM_EDITED>פסגות גדיש אגח עד 20% מניות</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>0.82</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>8.08</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>1353.53</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>1109.8946</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>1</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-0.93</TZVIRA_NETO>
    <ALPHA>0.12</ALPHA>
    <SHARP_RELATIVE>-0.87</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1.17</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    <GetTsuotKupotOneHodOuput>
    <ID>328</ID>
    <SHM>נייר אמריקאי</SHM>
    <SHM_EDITED>** נייר אמריקאי</SHM_EDITED>
    <TKUFA>201910</TKUFA>
    <MITZ_TKUFA>1.07</MITZ_TKUFA>
    <MITZ_MI_THILAT_SHANA>9.19</MITZ_MI_THILAT_SHANA>
    <YIT_NCHASIM_BFOAL>60.09</YIT_NCHASIM_BFOAL>
    <ID_STATUS_DIVUACH_TSUA>1</ID_STATUS_DIVUACH_TSUA>
    <SHM_STATUS_DIVUACH_TSUA>דווח</SHM_STATUS_DIVUACH_TSUA>
    <YIT_TSUA_TSUA_NOMINALI_BFOAL>64.2963</YIT_TSUA_TSUA_NOMINALI_BFOAL>
    <SHIUR_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_AHARON_HFKDT xsi:nil="true"/>
    <SHANA_DMEI_NIHUL_AHARON xsi:nil="true"/>
    <ID_UCLUSIYAT_YAAD>2</ID_UCLUSIYAT_YAAD>
    <TZVIRA_NETO>-0.19</TZVIRA_NETO>
    <ALPHA>0.6</ALPHA>
    <SHARP_RELATIVE>-0.6</SHARP_RELATIVE>
    <SHARP_ABSOLUTE>1</SHARP_ABSOLUTE>
    <YAHAS_NEZILUT xsi:nil="true"/>
    <ID_STATUS_DIVUACH>1</ID_STATUS_DIVUACH>
    <MITZ_MI_THILAT_SHANA_ALL>9.67468</MITZ_MI_THILAT_SHANA_ALL>
    <MITZ_TKUFA_ALL>1.11843</MITZ_TKUFA_ALL>
    <SHIUR_DMEI_NIHUL_ALL xsi:nil="true"/>
    <SHIUR_DMEI_NIHUL_HFKDT_ALL xsi:nil="true"/>
    <ID_PEILUT>1</ID_PEILUT>
    <YAHAS_NEZILUT_ALL xsi:nil="true"/>
    <SHARP_ABSOLUTE_ALL xsi:nil="true"/>
    <SHARP_RELATIVE_ALL xsi:nil="true"/>
    <ALPHA_ALL>0.82</ALPHA_ALL>
    </GetTsuotKupotOneHodOuput>
    </tns7:SpGetTsuotKupotOneHodOuput>
    </XmlData>
    </Query>

    everything works !!!

    It's as if there is a problem in the 'exchange' between Swagger and SSRS

    I'm using a REST API (GET) and the request is executed. THe problem is in reading the XML returned from Swagger

    Do you have any idea what is the problem ?

    Thanks

    0 comments No comments

  2. Michael Taylor 56,856 Reputation points
    2021-08-16T15:42:18.62+00:00

    I think you're misusing terms here. Swagger has nothing to do with what you posted. Swagger is an API description language that describes how to call an API and what the results are that come back. It is how we can automatically generate code and/or UIs to call the API without having to do it manually. It has nothing to do with actually calling the API. What you're showing is that you're making a call to a REST API and getting back XML data. You want to load this into SSRS.

    SSRS is not aware of REST APIs nor does it support calling them directly. There are many cases where it simply won't work including cases where you need to do authentication first. The preferred approach to calling a REST API, in my experience, is to use a script task (or a custom component if you know how) to make the call instead and then populate a data source from it. This resolves issues that you'll run into with calling APIs from SSRS.

    However, in the very specific case of a REST API that supports XML (instead of the more standard JSON) and doesn't require any authentication and returns relatively straightforward XML then you might get it to work using the standard XML data source. But be aware that even MS has recommended the use of third party code to do this rather than from SSRS directly. You can look in the old forums to see references if you want but they ultimately point to this blog article for a third party driver.

    The syntax you gave works because you're embedding an XML document into the query syntax as documented here. You're effectively hard coding the XML data which isn't useful for calling an API. To retrieve data from XML you have to define the XML elements to be read as discussed here.

    To verify that you can even get it to work as XML you should set the connection string to the full path to the endpoint you're calling in your data source. Then when you click Next it will call the API and show you the resulting XML. If you don't get anything then SSRS isn't going to be able to read it. If it does then you can use the link given earlier to filter down the actual data to pull. In your specific case the XML expression is going to start with the root tns element and then include the child output elements. But you're going to have to play around with it until you get it to work. Or forget trying to get it to work as a data source directly and just use a script task.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.