Difference between revisions of "User talk:Charlesnepote"

From Open Food Facts wiki
Jump to navigation Jump to search
(More complex examples)
(Test with 100 oils)
Line 45: Line 45:
 
{{!}} {{{code}}}
 
{{!}} {{{code}}}
 
{{!}} {{{name}}}
 
{{!}} {{{name}}}
 +
}}
 +
|}
 +
 +
== Data quality test ==
 +
 +
{{#get_web_data:
 +
url=https://world.openfoodfacts.org/category/vegetable-oils/nutrition-grade/b.json&fields=code,product_name&page_size=100
 +
|format=JSON
 +
|use jsonpath
 +
|data=code=$.products[*].code,name=$.products[*].product_name
 +
|cache seconds=360
 +
|use stale cache
 +
}}
 +
 +
Vegetable oils with Nutri-Score B:
 +
{| class="wikitable"
 +
! Name
 +
! Code
 +
{{#for_external_table:<nowiki/>
 +
{{!}}-
 +
{{!}} {{{name}}}
 +
{{!}} {{Product|{{{code}}}}}
 
}}
 
}}
 
|}
 
|}

Revision as of 15:22, 22 September 2021

I'm also going to use this page for some tests.


Simple test

Products with funny barcodes:

Code
7622210501240
4003171036249
0678963100206
6408430010998
4388844148840
4056489230403
23006096
5760466878333
4012824401983
4056489526872
8857124162105
4903333066254
5060250610058
6001108028044
4388844237773
5292705000064
6291002400019
8480000105684
7501020515343
8424790100146
8002469561421
20036188
4036303138467
4036303138481
4104060024931
4104060027789
4104060030772
4104060031533
4104060030796
4104060031304
4104060031427
4104060031649
4104060011184
4104060000041
4104060024726
4104060029196
8424790109040
8424790210029
8424790200037
8424790111012
8424790111005
8424790210036
8424790101341
8424790106025
5601024131111
5601024134136
5601024122522
5601024301231
40363486
40363028
40466071
5000181028133
4016241015228
7310865075376
5711953116681
20092016
7613033174667
7613033162220
7613036271868
7613037962215
7613036268882
7613037933017
7613034704436
7613032341640
7613036862295
7613034584236
7613035001848
7613035617216
7613033157776
7613031587339
7613034389398
7613033091391
5011546498492
5608531001043
5608531001036
0050000274444
0072310001770
0072310010925
5060490400051
8004673700320
4056489272410
3250391610389
3250390808411
3250391201327
40876191
4056489189121
4056489209997
4056489300786
4006952006912
4006952007896
4006952007940
4006952007902
20406561
4006952008121
4006952007421
4006952006943
4006952008169
4006952007049
7622210475411
7622210608741
8410000817911
7622300654177
7622300563523
7622300366827
7613031300655
8480000108487
8480000108128
8480000107480
7622210244864
20899677
8695077100092
5601175101124
5601050033014
5601175103135
5601244202318
5601244202677
5601244202660
5601244202684
5603722508752
5601244700005
5601244500063
5601244202332
5601244201960
4056489210009
6342462000315
6342462010000
3173286828204
20621483
4056489515951
5601009942121
5601050034516
5601244500070
0869198000137
29074945
4601576012624
20351168
4056489592402
5053827188531
3760122961876
5287001688047
4056489575375
4056489999515
4901330573041
4056489488194
6009881007614
4056489136354
8000500407394
3292590842345
4056489671442
3332930012073
8002885007480
8002885000573
4903333214327
5053827188876
20191948
4056489356066
6009881007645
4056489507802
8936119181168
0612322000776
189913891365460
7613031625758
4056489409069
20004101
4012824402614
4056489320456
3760279120171
5601050037838
7071688004614
8412600100325
4056489746911
4015637018904
5601050036985
3033491485756
7613036257183
5601050037869
4056489090069
20353889
4601075391923
8426904170533
4056489246053
8426904171875
8426904176849
8426904170687
8426904172650
8426904170786
8426904170069
8426904176351
8426904176344
8426904170700
8426904170601
0612322000790
40897677
20453459
5601244500162
5601241100006
5601055607029
5601009926091
7310865073556
8593807647223
5603722516764
5601050036251
4056489574408
5000112541007
0612322030087
3252210390014
20442767
5900852054822
20047214
8683130069073
5601314222208
5711953031885
4036300002648
4056489199861
9001745050283
8410014503329
3507001000161
5601244201984
3387390326468
3339572120005
42419075
5601241404005
5602691250785
5601511000012
3273221113195
4056489696216
5601050037104
20198107
5606293070123
5601055607005
5000181030938
8412600028605
20005719
8480000861603
20400811
5901716990621
4056489507765
4056489470717
5601050037272
7613036668378
4056489520542
4056489792475
3250392712525
20005726
4056489167037
5601050037777
5900020036988
8850389821060
4056489747475
20944575
3701239902123
20632984
5603722520594
5603729555995
20724696
4056489408932
5601050037289
20619848
7613032222109
3387390406719
3073780821155
20202392
20353032
7613036669498
4056489408918
5001705011457
4316268595865
20003548
5601050036909
4056489409052
5601050038132
20150907
20558123
20918507
5900020032799
4056489520504
20559625
20255138
5601050037517
5900020036179
3387390326574
8850389107089
5601163440020
20444006
8006460022004
8008440011121
20004132
20202408
5601050036268
5900020036162
7613038969510
8410500023652
4056489169819
20014384
56002621
3760122961760
20005733
20637682
20267605
7501059243873
5601511000708
8410500029593
20815394
20047238

Test with "product" macro

Products with funny barcodes:

Code
(see product 7622210501240 m)
(see product 4003171036249 m)
(see product 0678963100206 m)
(see product 6408430010998 m)
(see product 4388844148840 m)
(see product 4056489230403 m)
(see product 23006096 m)
(see product 5760466878333 m)
(see product 4012824401983 m)
(see product 4056489526872 m)
(see product 8857124162105 m)
(see product 4903333066254 m)
(see product 5060250610058 m)
(see product 6001108028044 m)
(see product 4388844237773 m)
(see product 5292705000064 m)
(see product 6291002400019 m)
(see product 8480000105684 m)
(see product 7501020515343 m)
(see product 8424790100146 m)
(see product 8002469561421 m)
(see product 20036188 m)
(see product 4036303138467 m)
(see product 4036303138481 m)
(see product 4104060024931 m)
(see product 4104060027789 m)
(see product 4104060030772 m)
(see product 4104060031533 m)
(see product 4104060030796 m)
(see product 4104060031304 m)
(see product 4104060031427 m)
(see product 4104060031649 m)
(see product 4104060011184 m)
(see product 4104060000041 m)
(see product 4104060024726 m)
(see product 4104060029196 m)
(see product 8424790109040 m)
(see product 8424790210029 m)
(see product 8424790200037 m)
(see product 8424790111012 m)
(see product 8424790111005 m)
(see product 8424790210036 m)
(see product 8424790101341 m)
(see product 8424790106025 m)
(see product 5601024131111 m)
(see product 5601024134136 m)
(see product 5601024122522 m)
(see product 5601024301231 m)
(see product 40363486 m)
(see product 40363028 m)
(see product 40466071 m)
(see product 5000181028133 m)
(see product 4016241015228 m)
(see product 7310865075376 m)
(see product 5711953116681 m)
(see product 20092016 m)
(see product 7613033174667 m)
(see product 7613033162220 m)
(see product 7613036271868 m)
(see product 7613037962215 m)
(see product 7613036268882 m)
(see product 7613037933017 m)
(see product 7613034704436 m)
(see product 7613032341640 m)
(see product 7613036862295 m)
(see product 7613034584236 m)
(see product 7613035001848 m)
(see product 7613035617216 m)
(see product 7613033157776 m)
(see product 7613031587339 m)
(see product 7613034389398 m)
(see product 7613033091391 m)
(see product 5011546498492 m)
(see product 5608531001043 m)
(see product 5608531001036 m)
(see product 0050000274444 m)
(see product 0072310001770 m)
(see product 0072310010925 m)
(see product 5060490400051 m)
(see product 8004673700320 m)
(see product 4056489272410 m)
(see product 3250391610389 m)
(see product 3250390808411 m)
(see product 3250391201327 m)
(see product 40876191 m)
(see product 4056489189121 m)
(see product 4056489209997 m)
(see product 4056489300786 m)
(see product 4006952006912 m)
(see product 4006952007896 m)
(see product 4006952007940 m)
(see product 4006952007902 m)
(see product 20406561 m)
(see product 4006952008121 m)
(see product 4006952007421 m)
(see product 4006952006943 m)
(see product 4006952008169 m)
(see product 4006952007049 m)
(see product 7622210475411 m)
(see product 7622210608741 m)
(see product 8410000817911 m)
(see product 7622300654177 m)
(see product 7622300563523 m)
(see product 7622300366827 m)
(see product 7613031300655 m)
(see product 8480000108487 m)
(see product 8480000108128 m)
(see product 8480000107480 m)
(see product 7622210244864 m)
(see product 20899677 m)
(see product 8695077100092 m)
(see product 5601175101124 m)
(see product 5601050033014 m)
(see product 5601175103135 m)
(see product 5601244202318 m)
(see product 5601244202677 m)
(see product 5601244202660 m)
(see product 5601244202684 m)
(see product 5603722508752 m)
(see product 5601244700005 m)
(see product 5601244500063 m)
(see product 5601244202332 m)
(see product 5601244201960 m)
(see product 4056489210009 m)
(see product 6342462000315 m)
(see product 6342462010000 m)
(see product 3173286828204 m)
(see product 20621483 m)
(see product 4056489515951 m)
(see product 5601009942121 m)
(see product 5601050034516 m)
(see product 5601244500070 m)
(see product 0869198000137 m)
(see product 29074945 m)
(see product 4601576012624 m)
(see product 20351168 m)
(see product 4056489592402 m)
(see product 5053827188531 m)
(see product 3760122961876 m)
(see product 5287001688047 m)
(see product 4056489575375 m)
(see product 4056489999515 m)
(see product 4901330573041 m)
(see product 4056489488194 m)
(see product 6009881007614 m)
(see product 4056489136354 m)
(see product 8000500407394 m)
(see product 3292590842345 m)
(see product 4056489671442 m)
(see product 3332930012073 m)
(see product 8002885007480 m)
(see product 8002885000573 m)
(see product 4903333214327 m)
(see product 5053827188876 m)
(see product 20191948 m)
(see product 4056489356066 m)
(see product 6009881007645 m)
(see product 4056489507802 m)
(see product 8936119181168 m)
(see product 0612322000776 m)
(see product 189913891365460 m)
(see product 7613031625758 m)
(see product 4056489409069 m)
(see product 20004101 m)
(see product 4012824402614 m)
(see product 4056489320456 m)
(see product 3760279120171 m)
(see product 5601050037838 m)
(see product 7071688004614 m)
(see product 8412600100325 m)
(see product 4056489746911 m)
(see product 4015637018904 m)
(see product 5601050036985 m)
(see product 3033491485756 m)
(see product 7613036257183 m)
(see product 5601050037869 m)
(see product 4056489090069 m)
(see product 20353889 m)
(see product 4601075391923 m)
(see product 8426904170533 m)
(see product 4056489246053 m)
(see product 8426904171875 m)
(see product 8426904176849 m)
(see product 8426904170687 m)
(see product 8426904172650 m)
(see product 8426904170786 m)
(see product 8426904170069 m)
(see product 8426904176351 m)
(see product 8426904176344 m)
(see product 8426904170700 m)
(see product 8426904170601 m)
(see product 0612322000790 m)
(see product 40897677 m)
(see product 20453459 m)
(see product 5601244500162 m)
(see product 5601241100006 m)
(see product 5601055607029 m)
(see product 5601009926091 m)
(see product 7310865073556 m)
(see product 8593807647223 m)
(see product 5603722516764 m)
(see product 5601050036251 m)
(see product 4056489574408 m)
(see product 5000112541007 m)
(see product 0612322030087 m)
(see product 3252210390014 m)
(see product 20442767 m)
(see product 5900852054822 m)
(see product 20047214 m)
(see product 8683130069073 m)
(see product 5601314222208 m)
(see product 5711953031885 m)
(see product 4036300002648 m)
(see product 4056489199861 m)
(see product 9001745050283 m)
(see product 8410014503329 m)
(see product 3507001000161 m)
(see product 5601244201984 m)
(see product 3387390326468 m)
(see product 3339572120005 m)
(see product 42419075 m)
(see product 5601241404005 m)
(see product 5602691250785 m)
(see product 5601511000012 m)
(see product 3273221113195 m)
(see product 4056489696216 m)
(see product 5601050037104 m)
(see product 20198107 m)
(see product 5606293070123 m)
(see product 5601055607005 m)
(see product 5000181030938 m)
(see product 8412600028605 m)
(see product 20005719 m)
(see product 8480000861603 m)
(see product 20400811 m)
(see product 5901716990621 m)
(see product 4056489507765 m)
(see product 4056489470717 m)
(see product 5601050037272 m)
(see product 7613036668378 m)
(see product 4056489520542 m)
(see product 4056489792475 m)
(see product 3250392712525 m)
(see product 20005726 m)
(see product 4056489167037 m)
(see product 5601050037777 m)
(see product 5900020036988 m)
(see product 8850389821060 m)
(see product 4056489747475 m)
(see product 20944575 m)
(see product 3701239902123 m)
(see product 20632984 m)
(see product 5603722520594 m)
(see product 5603729555995 m)
(see product 20724696 m)
(see product 4056489408932 m)
(see product 5601050037289 m)
(see product 20619848 m)
(see product 7613032222109 m)
(see product 3387390406719 m)
(see product 3073780821155 m)
(see product 20202392 m)
(see product 20353032 m)
(see product 7613036669498 m)
(see product 4056489408918 m)
(see product 5001705011457 m)
(see product 4316268595865 m)
(see product 20003548 m)
(see product 5601050036909 m)
(see product 4056489409052 m)
(see product 5601050038132 m)
(see product 20150907 m)
(see product 20558123 m)
(see product 20918507 m)
(see product 5900020032799 m)
(see product 4056489520504 m)
(see product 20559625 m)
(see product 20255138 m)
(see product 5601050037517 m)
(see product 5900020036179 m)
(see product 3387390326574 m)
(see product 8850389107089 m)
(see product 5601163440020 m)
(see product 20444006 m)
(see product 8006460022004 m)
(see product 8008440011121 m)
(see product 20004132 m)
(see product 20202408 m)
(see product 5601050036268 m)
(see product 5900020036162 m)
(see product 7613038969510 m)
(see product 8410500023652 m)
(see product 4056489169819 m)
(see product 20014384 m)
(see product 56002621 m)
(see product 3760122961760 m)
(see product 20005733 m)
(see product 20637682 m)
(see product 20267605 m)
(see product 7501059243873 m)
(see product 5601511000708 m)
(see product 8410500029593 m)
(see product 20815394 m)
(see product 20047238 m)

Rich test chaining two requests

Products with funny barcodes:

Code Name
20724696 Almonds
20267605 Cashews
20005733 Cerneaux de noix -nutriscore A- sans sel ajouté
20047238 Mélange de fruits secs
20815394 Fruit & Nut Mix
20150907 Сушени и захаросани боровинки
40897677 Hafer Flocken Zart
20202392 Brazil nuts
20005719 Pistazien gesalzen
4056489300786 Knusper Müsli Schoko
3252210390014
20005726
3387390326574
20003548 Pasta tartinabila cu alune de padure si cacao
20014384 Cacahuètes - grillées & salées
3033491485756 Hipro Fraise Framboise
20621483 Bran Flakes
20353032 Snack Mix Erdnüsse Oliven Mandeln
20004132 gehackte Tomaten
20047214 Mozzarella grated

Data quality test

Vegetable oils with Nutri-Score B:

Name Code

Nutrioli (see product 7501039120149 m)
Crinkle Cut Oven Chips (see product 20809973 m)
almond extract (see product 96081310 m)
Naturalia Avocado Oil (see product 0059749979702 m)
Grapefruit salad (see product 5050854467196 m)
tame and shine spray (see product 5012254058541 m)
castor oil (see product 0746092298054 m)
Olive oil flavoured with chilli (see product 01709834 m)
Butter Flavored Cooking Spray (see product 0021130512553 m)
Olio Extra Vergine di Oliva (see product 8056736503294 m)
Olio (see product 8005305600032 m)
Huile de tournesol (see product 5060463190002 m)
Original vegetable oil spray (see product 0040600341226 m)
Flavored no stick cooking spray (see product 0078742229423 m)
Sesame oil (see product 8210040351006 m)
Orzeszki z pieca (see product 5900571100039 m)
Organic Toasted Sesame Oil Unrefined (see product 0022506165052 m)
Roasted Sesame Oil (see product 0048002005852 m)
Extra Virgin Olive Oil (see product 9415102000833 m)
Huile d'olive vierge extra (see product 3266191014623 m)
Expeller Pressed Coconut Oil Cooking Spray (see product 0042563603854 m)
Aceite de coco (see product 7798260050233 m)
Cooking Spray, Original (see product 0040600215893 m)
Pure huile végétale (see product 6046000006400 m)
Sunflower oil (see product 5904413693031 m)
Coconut oil non-stick cooking spray (see product 0026700156182 m)
Virgin Sesame Oil (see product 0749544007709 m)
Huile vierge de colza (see product 3770000198003 m)
Omaar pure sunflower oil (see product 8691313988851 m)
Chill oil cooking spray (see product 5000442008089 m)
Aceite de oliva virgen extra ecológico (see product 8437010369896 m)
Grapeseed oil (see product 5010251481683 m)
Trader joe's, coconut oil spray (see product 00505000 m)
Roasted Hazelnut Oil (see product 0857190000118 m)
Centonze Case Di Latomie huile extra vierge olive (see product 8034105890046 m)
Canola oil (see product 7460193740405 m)
Huile de maïs (see product 0761720192122 m)
Pure wesson corn oil (see product 0027000650226 m)
Baking No-Stick Cooking Spray (see product 0041303043035 m)
Coconut oil (see product 0070404004522 m)
Avocado Oil (see product 0070404004539 m)
Olio di semi di mais (see product 8009113031118 m)
Canola cooking spray (see product 9415077035519 m)
Bakers baking spray (see product 0605021774000 m)
Organic Hemp Seed Oil Raw & Cold Pressed (see product 0692752100000 m)
Coconut Oil Cooking Spay (see product 0711535509042 m)
Canola oil (see product 9300601250769 m)
Healthy chef, butter cooking spray (see product 0849607090522 m)
Vegetable oil no-stick cooking spray (see product 0041303019221 m)
Canola Oil Cooking Spray (see product 0096619105502 m)
Aceite comestible puro de canola (see product 0096619597727 m)
Vegetable Oil Cooking Spray (see product 0078742229416 m)
Ghee cooking spray (see product 0742392931172 m)
Haricots verts (see product 00954464 m)
Canola Oil Cooking Spray (see product 0849607090515 m)
non stick cooking spray (see product 0036800459922 m)
Tahin chiaro (see product 8057733610039 m)
Detox citron (see product 04559757 m)
Spray butter (see product 0029000651517 m)
Avocado oil (see product 0041220414789 m)
Farchioni il casolare grezzo naturale olio extra (see product 8007153001849 m)
Huile de sesame (see product 4892958998227 m)
Urbani White Truffle Oil (see product 8000146500046 m)
Organic High Heat Sunflower Oil Refined (see product 0022506117105 m)
Shoprite, vegetable oil cooking spray (see product 0041190048625 m)
Grapeseed oil (see product 8002470028524 m)
Organic Avocado, Coconut & Safflower Oil Spray (see product 0853807005965 m)
Organic Extra Virgin Olive Spray Oil (see product 0854259005183 m)
Coconut oil non-stick cooking spray (see product 0022506138070 m)
Avocado Oil (see product 0857190000088 m)
Olive oil cooking spray (see product 0041190077557 m)
Olive Oil Non-Stick Cooking Spray (see product 0022506265813 m)
Organic Extra Virgin Olive Oil Cooking Spray (see product 0888670096222 m)
Olive cooking spray (see product 0038024206559 m)
Coconut Oil Non-Stick Cooking Spray (see product 0022506285606 m)
Pure canola oil (see product 0051500169483 m)
Huile vierge tournesol (see product 3760225600085 m)
Olive Oil Non-Stick Cooking Spray (see product 0022506800069 m)
Pure canola oil (see product 0051500736685 m)
Corn oil (see product 0761720056400 m)
Aceite de Maiz (see product 0761720987377 m)
Grapeseed Oil (see product 0041498239459 m)
Vegetable oil (see product 0070784443607 m)
Olio Sarullo (see product 8027965000038 m)
Huile tournesol (see product 4337182010289 m)
Avocado oil spray (see product 0671635701879 m)
Organic unrefined sunflower oil (see product 0069593120151 m)
Gmo hemp oil (see product 0844197011964 m)
Extra Virgin Olive Oil Gourmet Cooking Spray 16oz (see product 0075744006427 m)
Basil infused extra virgin olive oil spray (see product 4099100341287 m)
Huile tournesol (see product 3490390205029 m)
MAZOLA Óleo de Milho (see product 7894000030029 m)
Organic Extra Virgin Olive Oil Spray (see product 0646670316739 m)
Coconut oil cooking spray (see product 0481037814509 m)
(see product 8032584262590 m)
Olio extra vergine di oliva (see product 8032584260398 m)
ELOGIATA Óleo de Algodão Elogiata (see product 7898914796118 m)
Organic Hemp Seed Oil Raw & Cold Pressed (see product 0692752100093 m)
Huile d’argane (see product 6111262583867 m)
Organic hemp seed oil (see product 0697658201028 m)