Dear All
I try to get get some data from a xml, but I received null
I use compose: xpath(xml(body('Get_file_content')),'string(/declaratieUnica/angajator/@cif)')
I would like to get the value (string) 30163514
The xml is:
<?xml version="1.0"?>
<declaratieUnica xmlns="mfp:anaf:dgti:declaratie_unica:declaratie:v6" luna_r="01" an_r="2022" d_rec="0" nume_declar="ARDELEAN" prenume_declar="SIMONA" functie_declar="ADMINISTRATOR">
<angajator cif="30163514" rgCom="J35/1102/2012" caen="7022" den="GRAT SIM SRL" adrSoc="str. STR.POET GRIGORE ALEXANDRESCU,NR.2,CAMERA 1, loc. TIMISOARA, jud.TIMIS" telSoc="0722740906" adrFisc="str. STR.POET GRIGORE ALEXANDRESCU,NR.2,CAMERA 1, loc. TIMISOARA, jud.TIMIS" telFisc="0722740906" casaAng="TM" datCAM="1" cifAf1="0" cifAf2="0" pond1="0" bifa_CAM="0" totalPlata_A="1083">
<angajatorA A_codOblig="602" A_codBugetar="5503XXXXXX" A_datorat="133" A_deductibil="0" A_scutit="0" A_plata="133"/>
<angajatorA A_codOblig="412" A_codBugetar="5503XXXXXX" A_datorat="638" A_deductibil="0" A_scutit="0" A_plata="638"/>
<angajatorA A_codOblig="432" A_codBugetar="5503XXXXXX" A_datorat="255" A_deductibil="0" A_scutit="0" A_plata="255"/>
<angajatorA A_codOblig="480" A_codBugetar="20470300XX" A_datorat="57" A_deductibil="0" A_scutit="0" A_plata="57"/>
<angajatorB B_cnp="1" B_sanatate="1" B_pensie="1" B_sal="1" B_brutSalarii="2550"/>
<angajatorC1 C1_11="2550" C1_12="0" C1_13="0" C1_T1="2550" C1_T2="0" C1_T="0" C1_T3="0" C1_7="0"/>
<angajatorC2 C2_11="0" C2_12="0" C2_13="0" C2_14="0" C2_15="0" C2_16="0" C2_111="0" C2_112="0" C2_113="0" C2_114="0" C2_115="0" C2_116="0" C2_21="0" C2_22="0" C2_24="0" C2_26="0" C2_211="0" C2_212="0" C2_214="0" C2_216="0" C2_T6="0" C2_10="0" C2_140="0"/>
<angajatorC3 C3_11="0" C3_12="0" C3_13="0" C3_14="0" C3_total="0" C3_suma="0"/>
<angajatorC4 C4_baza="2550" C4_ct="57"/>
<angajatorD D2="0" D3="0"/>
<angajatorE1 E1_venit="0" E1_baza="0"/>
<angajatorE2 E2_11="0" E2_12="0" E2_14="0" E2_16="0" E2_21="0" E2_22="0" E2_24="0" E2_26="0" E2_31="0" E2_32="0" E2_34="0" E2_36="0" E2_41="0" E2_42="0" E2_44="0" E2_46="0" E2_51="0" E2_52="0" E2_54="0" E2_56="0" E2_66="0" E2_10="0"/>
<angajatorE3 E3_total="0" E3_suma="0"/>
<angajatorF1 F1_suma="133" F1_suma_ded="0" F1_deplata="133"/>
</angajator>
<asigurat cnpAsig="2820828350054" idAsig="1" numeAsig="ARDELEAN" prenAsig="SIMONA" dataAng="30.5.2012" casaSn="TM" asigCI="1" asigSO="1" Timp_E3="133">
<asiguratA A_1="26" A_2="0" A_3="N" A_4="8" A_6="160" A_7="0" A_8="20" A_9="2550" A_11="2550" A_12="255" A_13="2550" A_14="638" A_5="2550"/>
<asiguratE1 E1_1="2550" E1_2="893" E1_3="0" E1_4="330" E1_5="0" E1_6="1327" E1_7="133"/>
<asiguratE3 E3_1="A" E3_2="26" E3_3="1" E3_4="P" E3_8="2550" E3_9="893" E3_10="0" E3_11="0" E3_12="330" E3_13="0" E3_14="1327" E3_15="133" E3_16="1524" E3_18="0" E3_19="0" E3_21="0" E3_23="0"/>
</asigurat>
</declaratieUnica>
many thanks
Zolly
