Archived NeoSoft Support Forum

Hola amigos.

Estoy usando el plugin de anton, al menos probando.

Hago esto: y obtengo esto en [json] Quiero acceder a los datos del array pero no hay manera. Intento esto:
[json|element:(0)(REFERENCE)]
[json|element:(0)]
[json|element:3]
[json|element:('REFERENCE')]

Pero no hay manera de que me imprima solo el valor...

Pueden ayudarme?

Gracias!

djmarkes wrote:Hola amigos.

Estoy usando el plugin de anton, al menos probando.

Hago esto:

Code: Select all

bakInQuiryTableMySQL "SELECT" "SELECT * FROM products WHERE REFERENCE = '[refe]'" [json]

y obtengo esto en [json]

Code: Select all

[{"ID":"79795","REFERENCE":"FE20570158ECO","FAMILY_ID":"7882","MEASURE":"205/70R15C FEDERAL TL ECOVAN ( NEU)106S *E*","PRICE":"53.8","STOCK":"0","SLOPE":"0","ROLL_RESISTANCE":null,"BRAKING_DISTANCE":null,"NOISE_DB":null,"EAN_CODE":null,"MANUFACTURER_CODE":null,"FLAG_FIX_PRICE":"0","FLAG_GT2000":"0","SPEED_INDEX":null,"MEASURE_CODE":null,"MEASURE_WIDTH":null,"MEASURE_HEIGHT":null,"MEASURE_INCH":null},{"ID":"28837468","REFERENCE":"FE20570158ECO","FAMILY_ID":"7882","MEASURE":"205/70R15C TL ECOVAN (NEU)106S *E*","PRICE":"47.18","STOCK":"0","SLOPE":"31","ROLL_RESISTANCE":"E"}]

Quiero acceder a los datos del array pero no hay manera. Intento esto:
[json|element:(0)(REFERENCE)]
[json|element:(0)]
[json|element:3]
[json|element:('REFERENCE')]

Pero no hay manera de que me imprima solo el valor...

Pueden ayudarme?

Gracias!

[json(0)('REFERENCE')] = FE20570158ECO

En orden, para llevar el valor del elemento de la pantalla, para la variable correspondiente debe ejecutar setvar:
SetVar [REFERENCE] [json(0)('REFERENCE')]

[json(0)] = {"ID":"79795","REFERENCE":"FE20570158ECO","FAMILY_ID":"7882","MEASURE":"205/70R15C FEDERAL TL ECOVAN ( NEU)106S *E*","PRICE":"53.8","STOCK":"0","SLOPE":"0","ROLL_RESISTANCE":null,"BRAKING_DISTANCE":null,"NOISE_DB":null,"EAN_CODE":null,"MANUFACTURER_CODE":null,"FLAG_FIX_PRICE":"0","FLAG_GT2000":"0","SPEED_INDEX":null,"MEASURE_CODE":null,"MEASURE_WIDTH":null,"MEASURE_HEIGHT":null,"MEASURE_INCH":null}


[json(1)('FAMILY_ID')] = 7882

En orden, para llevar el valor del elemento de la pantalla, para la variable correspondiente debe ejecutar setvar:
SetVar [FAMILY_ID] [json(1)('FAMILY_ID')]

[json(1)] = {"ID":"28837468","REFERENCE":"FE20570158ECO","FAMILY_ID":"7882","MEASURE":"205/70R15C TL ECOVAN (NEU)106S *E*","PRICE":"47.18","STOCK":"0","SLOPE":"31","ROLL_RESISTANCE":"E"}