11
Web Server - Ask For Help / Re: Web Service Method - parallel nested tables
« Last post by Niels Larsen on December 04, 2023, 05:50:23 AM »Hi Seanh
I totally agree. My wish is to insert 2 arrays at the same level and still have the automatic documentation generated. My hope is that I can insert an array into the existing structure in another way than via a view. I can't quite see whether the template allows for this or whether there is an embed point to do that.
Just read your reply again. It's not a SQL union I'm looking for. Invoice and Order could be two completely different tables with completely different structures.
I totally agree. My wish is to insert 2 arrays at the same level and still have the automatic documentation generated. My hope is that I can insert an array into the existing structure in another way than via a view. I can't quite see whether the template allows for this or whether there is an embed point to do that.
Just read your reply again. It's not a SQL union I'm looking for. Invoice and Order could be two completely different tables with completely different structures.
12
Web Server - Ask For Help / Re: Web Service Method - parallel nested tables
« Last post by seanh on December 04, 2023, 03:27:06 AM »I think I understand what you want. and no, a view cannot do that.
The View is doing exactly as it should in duplicating everything. A view does that, it flatterns the data and gives you everything.
If you're backend is TPS, you need to do some programming, maybe with a temporary table.
What you want in SQL terms is called a UNION, and you need to create that as an SQL VIEW on the backend.
The View is doing exactly as it should in duplicating everything. A view does that, it flatterns the data and gives you everything.
If you're backend is TPS, you need to do some programming, maybe with a temporary table.
What you want in SQL terms is called a UNION, and you need to create that as an SQL VIEW on the backend.
13
Web Server - Ask For Help / Re: Windows Popup Message
« Last post by Niels Larsen on December 01, 2023, 01:28:54 AM »Take a look at Notifikation here: https://www.capesoft.com/docs/NetTalk12/NetTalkWebBasic.htm
14
Web Server - Ask For Help / Re: Windows Popup Message
« Last post by ntnewbies on December 01, 2023, 01:09:35 AM »Hi Rupert,
In addition to what Alberto suggested, i hv also used this to popup a message at the browser:
p_web.Script('ntAlert("Payment Received.","Kaching!");')
regards,
Jason
c11
nt12.62
In addition to what Alberto suggested, i hv also used this to popup a message at the browser:
p_web.Script('ntAlert("Payment Received.","Kaching!");')
regards,
Jason
c11
nt12.62
15
Web Server - Ask For Help / Re: Windows Popup Message
« Last post by rupertvz on December 01, 2023, 12:44:08 AM »Thank you Alberto,
But the client needs to be in the web app to receive the message?
Sorry, I left out to say, the popup should happen in the their browser, even if they are on another website,
Or in Windows, perhaps from the tray?
But the client needs to be in the web app to receive the message?
Sorry, I left out to say, the popup should happen in the their browser, even if they are on another website,
Or in Windows, perhaps from the tray?
16
Web Server - Ask For Help / Re: Web Service Method - parallel nested tables
« Last post by Niels Larsen on November 30, 2023, 08:50:53 PM »Hi Alberto
There are several regions per customer, so I think the structure is ok.
I understand what you mean, but that is not the point of my challenge. The data structure is intended only as a test.
The challenge is to have two different arrays under each region and I don't think I can achieve that via a clarion view structure.
Regards Niels
There are several regions per customer, so I think the structure is ok.
I understand what you mean, but that is not the point of my challenge. The data structure is intended only as a test.
The challenge is to have two different arrays under each region and I don't think I can achieve that via a clarion view structure.
Regards Niels
17
Web Server - Ask For Help / Re: Web Service Method - parallel nested tables
« Last post by Alberto on November 30, 2023, 06:10:28 AM »Hi Niels Larsen,
I dont fully undestand what you are tryinig to do but If you need to retreive only the invoices from each customer, in the customer node... at least you need a customer Field and a key in the invoices file.
What the view is doing is ok, you are asking for all the invoices in the regison inside each customer.
If you need a help doing the view make an ABC Browse linking the files as you need, once this browse shows what you want, just see the souce and duplicate it in the API method
Regards
I dont fully undestand what you are tryinig to do but If you need to retreive only the invoices from each customer, in the customer node... at least you need a customer Field and a key in the invoices file.
What the view is doing is ok, you are asking for all the invoices in the regison inside each customer.
If you need a help doing the view make an ABC Browse linking the files as you need, once this browse shows what you want, just see the souce and duplicate it in the API method
Regards
18
Web Server - Ask For Help / Re: Windows Popup Message
« Last post by Alberto on November 30, 2023, 05:44:33 AM »Hi rupertvz, you can use any of these:
p_web.Script('window.alert("Your message")')
p_web.popup('message', , 1, 'caption' )
p_web.Message()
Regards
p_web.Script('window.alert("Your message")')
p_web.popup('message', , 1, 'caption' )
p_web.Message()
Regards
19
Web Server - Ask For Help / Windows Popup Message
« Last post by rupertvz on November 30, 2023, 03:52:55 AM »Hi Guys,
Not sure if this is the correct place to ask, but perhaps someone could make a suggestion,
I am looking for a Windows Popup Message template.
For example, when transactions are pending approval in the application database, it should prompt the user and give a popup message accordingly.
Not sure if this is the correct place to ask, but perhaps someone could make a suggestion,
I am looking for a Windows Popup Message template.
For example, when transactions are pending approval in the application database, it should prompt the user and give a popup message accordingly.
20
Web Server - Ask For Help / Re: Web Service Method - parallel nested tables
« Last post by Niels Larsen on November 30, 2023, 12:13:01 AM »For each customer there is 3 Regions. For each Region there is 4 Orders and 4 Invoices.
The orders are displayed correctly - 4 per Region, but the invoices are displayed 4 times the number of Regions, 16 times (the same 4 invoices are displayed 4 times).
I have attached a test app. On the Web Server window I have placed a button for generating test data. There are 10 customers from 1 - 10.
The orders are displayed correctly - 4 per Region, but the invoices are displayed 4 times the number of Regions, 16 times (the same 4 invoices are displayed 4 times).
I have attached a test app. On the Web Server window I have placed a button for generating test data. There are 10 customers from 1 - 10.
Code: [Select]
CustomerView VIEW(Customer)
Project(CUS:GUID)
Project(CUS:Number)
Project(CUS:Name)
JOIN(REG:Customer_KEY,CUS:GUID)
JOIN(ORD:Region_KEY,REG:GUID)
END
JOIN(INV:Region_KEY,REG:GUID)
END
END
END
Code: [Select]
{
"databaseCustomer_response" : {
"customer" : [
{
"guid" : "6F6TMD0K-I55I-Z7WI-Z3Q4-YR8TTZUXP2IU",
"number" : 1,
"name" : "HO8W6UC3ATNOVPRKVQ4L",
"region" : [
{
"guid" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"customer" : "6F6TMD0K-I55I-Z7WI-Z3Q4-YR8TTZUXP2IU",
"name" : "K8Q6FF1XUPOMADMUH487",
"orders" : [
{
"number" : 1,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "MGZKGGW2U42TUJG7DB9NJ4ZS8AQ3OV9Q95A3SZ4CA2WZQABSBEA2IL627MC1QDWOWMFJR88N4DN34AO0ZU5FBCCFJM81822NOZCJ"
},
{
"number" : 2,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "WBYT3UXFM8W4VGZ9BOG90WDSU1BFYZQ1EEETFBWA5IDI4MWQETGTFTRN7UXERYTEVW7VABVJKR7B1W9ZYNUUG6KIZ0ISBPVESUF5"
},
{
"number" : 3,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "DIP39T5ZRNP7BNM1R8RZEJSX63YDIQ6QDMENOZ6ZNIRG4R2QLGUNUNTLLTZE7UNG0XOH93T7BXJJ3XGH69UMFQVJ4TTVYRACB6P5"
},
{
"number" : 4,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "CPWKCT7YS96MFAXSI4GUYCWWX0LDRU8J775I6U1PQPHG9VHCE0FEN9VLML7CHJP7HDLD9IRC0YZ2PNH84OAT1HQ468T9T16S7X5T"
}
],
"invoices" : [
{
"number" : 1,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "2MJ4MTEYS218HXN82GVRA88KA3DUAIY5X1RUNX6R1OHN0JZ31RVRP5HX9AL66TU9TF7UNWXNZ44JNVRXUD5Y6HPOKWR72SEE5BH9"
},
{
"number" : 2,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "OCCG3QEDTGCNC7NVL45PA8TEARHXXKNIEPR77UBRSBJROPI6KNLSYJMW8JPSNY62Q5OTDU3HEISKO2IWPQ4FP3EY5EDIPVCR7J9Y"
},
{
"number" : 3,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "VAEY2TMVY7SWETVNDJ472PKTFVDU2BO9QF6BUN02YFSU6SS80XURB24UIJU3DRDIVXEYHDX31JJJQ4NZ3MEV654Q0T7AUVPR6T37"
},
{
"number" : 4,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "0EDHIYVOYZOY9D053QXCTPJE3160J7WWS45JD9DTQK5U4MBQGGFWU0TMW74J1MRHFQTL74YJWVHF91P7N3MKY0DR1DUOYZHRYQT9"
},
{
"number" : 1,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "2MJ4MTEYS218HXN82GVRA88KA3DUAIY5X1RUNX6R1OHN0JZ31RVRP5HX9AL66TU9TF7UNWXNZ44JNVRXUD5Y6HPOKWR72SEE5BH9"
},
{
"number" : 2,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "OCCG3QEDTGCNC7NVL45PA8TEARHXXKNIEPR77UBRSBJROPI6KNLSYJMW8JPSNY62Q5OTDU3HEISKO2IWPQ4FP3EY5EDIPVCR7J9Y"
},
{
"number" : 3,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "VAEY2TMVY7SWETVNDJ472PKTFVDU2BO9QF6BUN02YFSU6SS80XURB24UIJU3DRDIVXEYHDX31JJJQ4NZ3MEV654Q0T7AUVPR6T37"
},
{
"number" : 4,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "0EDHIYVOYZOY9D053QXCTPJE3160J7WWS45JD9DTQK5U4MBQGGFWU0TMW74J1MRHFQTL74YJWVHF91P7N3MKY0DR1DUOYZHRYQT9"
},
{
"number" : 1,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "2MJ4MTEYS218HXN82GVRA88KA3DUAIY5X1RUNX6R1OHN0JZ31RVRP5HX9AL66TU9TF7UNWXNZ44JNVRXUD5Y6HPOKWR72SEE5BH9"
},
{
"number" : 2,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "OCCG3QEDTGCNC7NVL45PA8TEARHXXKNIEPR77UBRSBJROPI6KNLSYJMW8JPSNY62Q5OTDU3HEISKO2IWPQ4FP3EY5EDIPVCR7J9Y"
},
{
"number" : 3,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "VAEY2TMVY7SWETVNDJ472PKTFVDU2BO9QF6BUN02YFSU6SS80XURB24UIJU3DRDIVXEYHDX31JJJQ4NZ3MEV654Q0T7AUVPR6T37"
},
{
"number" : 4,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "0EDHIYVOYZOY9D053QXCTPJE3160J7WWS45JD9DTQK5U4MBQGGFWU0TMW74J1MRHFQTL74YJWVHF91P7N3MKY0DR1DUOYZHRYQT9"
},
{
"number" : 1,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "2MJ4MTEYS218HXN82GVRA88KA3DUAIY5X1RUNX6R1OHN0JZ31RVRP5HX9AL66TU9TF7UNWXNZ44JNVRXUD5Y6HPOKWR72SEE5BH9"
},
{
"number" : 2,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "OCCG3QEDTGCNC7NVL45PA8TEARHXXKNIEPR77UBRSBJROPI6KNLSYJMW8JPSNY62Q5OTDU3HEISKO2IWPQ4FP3EY5EDIPVCR7J9Y"
},
{
"number" : 3,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "VAEY2TMVY7SWETVNDJ472PKTFVDU2BO9QF6BUN02YFSU6SS80XURB24UIJU3DRDIVXEYHDX31JJJQ4NZ3MEV654Q0T7AUVPR6T37"
},
{
"number" : 4,
"region" : "UY1YK6IG-PZBE-CAVL-5BKA-3WC91IXV6PBI",
"text" : "0EDHIYVOYZOY9D053QXCTPJE3160J7WWS45JD9DTQK5U4MBQGGFWU0TMW74J1MRHFQTL74YJWVHF91P7N3MKY0DR1DUOYZHRYQT9"
}
]
},
{
"guid" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"customer" : "6F6TMD0K-I55I-Z7WI-Z3Q4-YR8TTZUXP2IU",
"name" : "RJDN03XFHLIEGPN76QWQ",
"orders" : [
{
"number" : 5,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "JD9DH9ZT1AS36676E31BPCKFR1I164KA9EKC71KW7IYISCGD66FXMQ0JCDNJ6QVF7SREO9CHRPG4OSXS3LE700VE32TB7JQ6ZDGM"
},
{
"number" : 6,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "QY0OZITB8IW8YFUZN4VV9UK0HSZX6ONPI5ET9BJP5PRO15DXQ8VE9UZX6NKAHUKFD3HC6H22KTGDTWHWOC76NZZN07037Q9XR2M4"
},
{
"number" : 7,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "GRWCMPB5ZGEB5HS2J06SK9GSNBOEXNEGLF0HZEO70HJI9R9PV23NHZ0MU1ULE7BW6DK5G9TQLYLPGXIRV7Y8JBHZBVRUCFQGK7LO"
},
{
"number" : 8,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "PWPCN03701LJUFUQ9G44N9GMO75F33IDN1UWRVSZ2FT50ISOLN3PS6WS9GW19OHPLQUH528FRHXURC0YYBTU2OK2C28YICXZOSKK"
}
],
"invoices" : [
{
"number" : 5,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "RM69340CY2UTAGZXOJC2WCR7JKBIAJKLSSAHBZBH2LWWOAFFD7SWKTM24O1AXP55UXFWURULM1KIEAJ36H926RGF4XMXJS1DPN6W"
},
{
"number" : 6,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "67G63ZVCHV81IOECQNOPCKSGNRRAM1V8H4TXPF60ZLLBRW7HXAMPRXH462PI6S07KBCJX01P2OTJ17F9NBHUXDY66UZQ2OR6DZU0"
},
{
"number" : 7,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "NWEWFNW3CCK2Q1ZECEGG6TVN5NTGTYXU19J7R8B1FUC4QA37BWPBAANZNDXCWM4V94WC9Z7972N7LNSMSO3NC9OM85LT70Q6RW9F"
},
{
"number" : 8,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "L8PNE3WFCMDRBSFFJMB5DABE25OKY8TQH4H9HDS9A0FV0LMBKDCTCZQTFBU5ARPBEVWOAQJCW67OC0UL2PWT0A5A02VVD0I4EBKE"
},
{
"number" : 5,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "RM69340CY2UTAGZXOJC2WCR7JKBIAJKLSSAHBZBH2LWWOAFFD7SWKTM24O1AXP55UXFWURULM1KIEAJ36H926RGF4XMXJS1DPN6W"
},
{
"number" : 6,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "67G63ZVCHV81IOECQNOPCKSGNRRAM1V8H4TXPF60ZLLBRW7HXAMPRXH462PI6S07KBCJX01P2OTJ17F9NBHUXDY66UZQ2OR6DZU0"
},
{
"number" : 7,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "NWEWFNW3CCK2Q1ZECEGG6TVN5NTGTYXU19J7R8B1FUC4QA37BWPBAANZNDXCWM4V94WC9Z7972N7LNSMSO3NC9OM85LT70Q6RW9F"
},
{
"number" : 8,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "L8PNE3WFCMDRBSFFJMB5DABE25OKY8TQH4H9HDS9A0FV0LMBKDCTCZQTFBU5ARPBEVWOAQJCW67OC0UL2PWT0A5A02VVD0I4EBKE"
},
{
"number" : 5,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "RM69340CY2UTAGZXOJC2WCR7JKBIAJKLSSAHBZBH2LWWOAFFD7SWKTM24O1AXP55UXFWURULM1KIEAJ36H926RGF4XMXJS1DPN6W"
},
{
"number" : 6,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "67G63ZVCHV81IOECQNOPCKSGNRRAM1V8H4TXPF60ZLLBRW7HXAMPRXH462PI6S07KBCJX01P2OTJ17F9NBHUXDY66UZQ2OR6DZU0"
},
{
"number" : 7,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "NWEWFNW3CCK2Q1ZECEGG6TVN5NTGTYXU19J7R8B1FUC4QA37BWPBAANZNDXCWM4V94WC9Z7972N7LNSMSO3NC9OM85LT70Q6RW9F"
},
{
"number" : 8,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "L8PNE3WFCMDRBSFFJMB5DABE25OKY8TQH4H9HDS9A0FV0LMBKDCTCZQTFBU5ARPBEVWOAQJCW67OC0UL2PWT0A5A02VVD0I4EBKE"
},
{
"number" : 5,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "RM69340CY2UTAGZXOJC2WCR7JKBIAJKLSSAHBZBH2LWWOAFFD7SWKTM24O1AXP55UXFWURULM1KIEAJ36H926RGF4XMXJS1DPN6W"
},
{
"number" : 6,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "67G63ZVCHV81IOECQNOPCKSGNRRAM1V8H4TXPF60ZLLBRW7HXAMPRXH462PI6S07KBCJX01P2OTJ17F9NBHUXDY66UZQ2OR6DZU0"
},
{
"number" : 7,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "NWEWFNW3CCK2Q1ZECEGG6TVN5NTGTYXU19J7R8B1FUC4QA37BWPBAANZNDXCWM4V94WC9Z7972N7LNSMSO3NC9OM85LT70Q6RW9F"
},
{
"number" : 8,
"region" : "D25DL884-BH5Y-37A8-OE14-ZI6RY75VZQEA",
"text" : "L8PNE3WFCMDRBSFFJMB5DABE25OKY8TQH4H9HDS9A0FV0LMBKDCTCZQTFBU5ARPBEVWOAQJCW67OC0UL2PWT0A5A02VVD0I4EBKE"
}
]
},
{
"guid" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"customer" : "6F6TMD0K-I55I-Z7WI-Z3Q4-YR8TTZUXP2IU",
"name" : "801DE2BYJAB95LB5UIHM",
"orders" : [
{
"number" : 9,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "T7W2HPEKM8GPFIOL2M1M9YDRWEVLFSL9EHDF59JPUNPN9Z4E7FI5NZPSB3XMC5LTKTWS9D76JYUW3UY67G8JUGCXRO1F8EEQODZN"
},
{
"number" : 10,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "SO234GVOJNMQCB5HVPXSZRHMNLY4S0HH3BINA1E11RC1DAECRP6AVHMZ933HGES2E3S3EXLX6COZ4GYCKJPRYDRV7BX3X14ONEF2"
},
{
"number" : 11,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "4K0TRFP45PGM0WW91BWK8O0YRVNHTLEYBDAW1BDP4S9H13TLAHTMPQ6KL3LD6Q7KJQLZNPKC33VKV8MTY8SO9UNDEQ7IOKRYD2U3"
},
{
"number" : 12,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "GJXL5R4VHIXOZ12EW91ZLDJ8NLREYC68FM84XB8D8M43T2REX2F9IWZEO9JR65TC81ASCMN0OTWKDXPRZIF70TJHKZW7DCIQSFPV"
}
],
"invoices" : [
{
"number" : 9,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "X6T6RNEFEANVJ8D30NKOJ7ZX9BJK21GATP4KR52LJWRY0LW0BBZ2ZG1XH8STW9ZPB94ZYGHIOD5BOXOWI92LN7Z8QV68T8SJAMT1"
},
{
"number" : 10,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "ZB6PBQUALQM7GDPMKXZK1GAH5IEV6LNO8W077X0R9EPSEC8SVSNNIW651S78F9S2PQMQ9RKUA9P6GW5S9OS4IEYSB8JNW91TEO7A"
},
{
"number" : 11,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "AUFDJTX44ATJT5HSVRL8M0N9RWZ5I8TAIXBAZF3SZF31K9SNINA1OXLAU26BI2XERQ4K7828RY8DE2KJGJTJ8DXMEJW1CTKPOJZN"
},
{
"number" : 12,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "5KPRLJKXVOPYY7X948OY4D1CV4N899NTFQY4ZQY7ZVSU5ZKEE6UMAQSGH5778SDKD2GI2EJ0CKI8D9U1BI5Y75WPTQ27A28PP223"
},
{
"number" : 9,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "X6T6RNEFEANVJ8D30NKOJ7ZX9BJK21GATP4KR52LJWRY0LW0BBZ2ZG1XH8STW9ZPB94ZYGHIOD5BOXOWI92LN7Z8QV68T8SJAMT1"
},
{
"number" : 10,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "ZB6PBQUALQM7GDPMKXZK1GAH5IEV6LNO8W077X0R9EPSEC8SVSNNIW651S78F9S2PQMQ9RKUA9P6GW5S9OS4IEYSB8JNW91TEO7A"
},
{
"number" : 11,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "AUFDJTX44ATJT5HSVRL8M0N9RWZ5I8TAIXBAZF3SZF31K9SNINA1OXLAU26BI2XERQ4K7828RY8DE2KJGJTJ8DXMEJW1CTKPOJZN"
},
{
"number" : 12,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "5KPRLJKXVOPYY7X948OY4D1CV4N899NTFQY4ZQY7ZVSU5ZKEE6UMAQSGH5778SDKD2GI2EJ0CKI8D9U1BI5Y75WPTQ27A28PP223"
},
{
"number" : 9,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "X6T6RNEFEANVJ8D30NKOJ7ZX9BJK21GATP4KR52LJWRY0LW0BBZ2ZG1XH8STW9ZPB94ZYGHIOD5BOXOWI92LN7Z8QV68T8SJAMT1"
},
{
"number" : 10,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "ZB6PBQUALQM7GDPMKXZK1GAH5IEV6LNO8W077X0R9EPSEC8SVSNNIW651S78F9S2PQMQ9RKUA9P6GW5S9OS4IEYSB8JNW91TEO7A"
},
{
"number" : 11,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "AUFDJTX44ATJT5HSVRL8M0N9RWZ5I8TAIXBAZF3SZF31K9SNINA1OXLAU26BI2XERQ4K7828RY8DE2KJGJTJ8DXMEJW1CTKPOJZN"
},
{
"number" : 12,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "5KPRLJKXVOPYY7X948OY4D1CV4N899NTFQY4ZQY7ZVSU5ZKEE6UMAQSGH5778SDKD2GI2EJ0CKI8D9U1BI5Y75WPTQ27A28PP223"
},
{
"number" : 9,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "X6T6RNEFEANVJ8D30NKOJ7ZX9BJK21GATP4KR52LJWRY0LW0BBZ2ZG1XH8STW9ZPB94ZYGHIOD5BOXOWI92LN7Z8QV68T8SJAMT1"
},
{
"number" : 10,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "ZB6PBQUALQM7GDPMKXZK1GAH5IEV6LNO8W077X0R9EPSEC8SVSNNIW651S78F9S2PQMQ9RKUA9P6GW5S9OS4IEYSB8JNW91TEO7A"
},
{
"number" : 11,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "AUFDJTX44ATJT5HSVRL8M0N9RWZ5I8TAIXBAZF3SZF31K9SNINA1OXLAU26BI2XERQ4K7828RY8DE2KJGJTJ8DXMEJW1CTKPOJZN"
},
{
"number" : 12,
"region" : "F4NN5J7N-IGF1-QNMF-8RXY-NDH918LH72R7",
"text" : "5KPRLJKXVOPYY7X948OY4D1CV4N899NTFQY4ZQY7ZVSU5ZKEE6UMAQSGH5778SDKD2GI2EJ0CKI8D9U1BI5Y75WPTQ27A28PP223"
}
]
}
]
}
],
"skippedrecords" : "0",
"resultcomplete" : "1"
}
}