1b.app
Link copied -

finalize the action

it is necessary to refine the action "Integration of business processes XML (Import)" in such a way that it is possible to load data that is in the json structure in stacked arrays
for example
in add. the process field "Ref of the New Post office" needs to load the value that is in the nested array
array shipping_line
I attach an example of processed json
Original question is available on version: ru

Answers:

Variables can be specified as a nesting path by separating them with /
That is, if you specify aaa/bbb/ccc, then from the array with the key aaa it will try to get the array by the bbb key, and from it the element by the ccc key
The only thing is that this enumeration does not support 0 in the path - but this can be finalized in 1 hour.
Is this option right for you? Or do you need something else?
22.01.2021, 16:44
Original comment available on version: ru

Перегиняк Александр
Oneboxconsulting (интегратор)

Tyndyk Maxim Vadimovich
Administrator wrote:
The only thing is that this enumeration does not support 0 in the path - but this can be finalized in 1 hour.

invoice please
25.01.2021, 12:00
Original comment available on version: ru

Перегиняк Александр
Oneboxconsulting (интегратор)

Tyndyk Maxim Vadimovich
Administrator wrote:
Variables can be specified as a nesting path by separating them with /
That is, if you specify aaa/bbb/ccc, then from the array with the key aaa it will try to get the array by the bbb key, and from it the element by the ccc key
The only thing is that this enumeration does not support 0 in the path - but this can be finalized in 1 hour.
Is this option right for you? Or do you need something else?

the problem is that the array passed as a nested array can be dynamic - in some cases the key "aaa" will be in the first line, and in other cases, this key will move to the tenth line. It turns out that you need to search for the parameter value in the nested array by the desired key.
Can you evaluate how to implement it?
25.01.2021, 12:02
Original comment available on version: ru


Pereginyak Alexander
Oneboxconsulting (integrator) wrote:
the problem is that the array passed as a nested array can be dynamic - in some cases the key "aaa" will be in the first line, and in other cases, this key will move to the tenth line. It turns out that you need to search for the parameter value in the nested array by the desired key.
Can you evaluate how to implement it?

If you provide logic, then we will evaluate it.
So far, I don't understand the logic from your comment. Let's take a look at your examples.
25.01.2021, 14:10
Original comment available on version: ru

Перегиняк Александр
Oneboxconsulting (интегратор)

Tyndyk Maxim Vadimovich
Administrator wrote:
If you provide logic, then we will evaluate it.
So far, I don't understand the logic from your comment. Let's take a look at your examples.

in the line where the parameters of processing are specified add
1. checkbox "search in the stacked array and write the result to the specified OneBox field"
2. field "identifier of keys in the array (what is the name of the array column in which parameter identifiers are stored)"
3. field "identifier of the desired key in the array (what is the name of the desired parameter (key), the value of which you want to get)"
4. field "identifier of the field with values in the array (what is the name of the array column in which parameter values are stored)"
if the checkbox is checked and all fields 2-4 are filled, then
get an array that is stored at the address specified in the "Additional field key" field and try to get the value of the array element stored in the column from step 4 for the string whose address was obtained by searching the column from step 2 for the value from step 3
do you still need an example?
25.01.2021, 14:52
Original comment available on version: ru


Pereginyak Alexander wrote:
do you still need an example?

better yes
because the description is not obvious to me - I don’t think that it will be obvious / convenient for any of the clients later
27.01.2021, 18:06
Original comment available on version: ru

Перегиняк Александр
Oneboxconsulting (интегратор)

Pereginyak Alexander
Oneboxconsulting (integrator) wrote:

Tyndyk Maxim Vadimovich
Administrator wrote:
The only thing is that this enumeration does not support 0 in the path - but this can be finalized in 1 hour.

invoice please

invoice please
11.02.2021, 14:08
Original comment available on version: ru


Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment