The search UI is available here: https://app.powerbi.com/view?r=eyJrIjoiN2U3NGMyNWEtZTAxNS00MzVhLWExNmMtOThhZjdiYjQ4MWNkIiwidCI6IjEyNGU2OWRiLWVmNjUtNDk2Yi05NmE5LTVkNTZiZWMxZDI5MSIsImMiOjl9
The application works be sending a POST request to the following URL: https://wabi-west-europe-api.analysis.windows.net/public/reports/querydata?synchronous=true
The POST request's body is the following:
{
"version": "1.0.0",
"queries": [{
"Query": {
"Commands": [{
"SemanticQueryDataShapeCommand": {
"Query": {
"Version": 2,
"From": [{
"Name": "o",
"Entity": "Organization",
"Type": 0
}, {
"Name": "c",
"Entity": "Certificate",
"Type": 0
}, {
"Name": "c2",
"Entity": "Country Data",
"Type": 0
}],
"Select": [{
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "Organization Name"
},
"Name": "Organization.Name"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "c"
}
},
"Property": "License"
},
"Name": "Certificate.License"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "c"
}
},
"Property": "Date_From__c"
},
"Name": "Certificate.Date_From__c"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "c"
}
},
"Property": "Date_To__c"
},
"Name": "Certificate.Date_To__c"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "c"
}
},
"Property": "Full_Certificate_Code__c"
},
"Name": "Certificate.Full_Certificate_Code__c"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "c2"
}
},
"Property": "Country"
},
"Name": "Country Data.Country"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "c"
}
},
"Property": "status"
},
"Name": "Certificate.status"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "Type (groups)"
},
"Name": "Organization.Type (groups)"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "c"
}
},
"Property": "CW"
},
"Name": "Certificate.CW"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "State_County__c"
},
"Name": "Organization.State_County__c"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "Site status"
},
"Name": "Organization.Site status"
}],
"Where": [{
"Condition": {
"In": {
"Expressions": [{
"Column": {
"Expression": {
"SourceRef": {
"Source": "c"
}
},
"Property": "status"
}
}],
"Values": [
[{
"Literal": {
"Value": "'Valid'"
}
}]
]
}
}
}, {
"Condition": {
"Not": {
"Expression": {
"In": {
"Expressions": [{
"Column": {
"Expression": {
"SourceRef": {
"Source": "c"
}
},
"Property": "Cert_Status__c"
}
}],
"Values": [
[{
"Literal": {
"Value": "null"
}
}],
[{
"Literal": {
"Value": "'Applicant'"
}
}]
]
}
}
}
}
}],
"OrderBy": [{
"Direction": 2,
"Expression": {
"Column": {
"Expression": {
"SourceRef": {
"Source": "c"
}
},
"Property": "Date_From__c"
}
}
}]
},
"Binding": {
"Primary": {
"Groupings": [{
"Projections": [1, 4, 6, 8, 2, 3, 0, 7, 10, 9, 5],
"ShowItemsWithNoData": [1, 4, 6, 8, 2, 3, 0, 7, 10, 9, 5]
}]
},
"DataReduction": {
"DataVolume": 3,
"Primary": {
"Window": {
"Count": 500,
"RestartTokens": [
["datetime'2023-01-08T00:00:00'", "'FSC-C016072'", "'SGSCH-FM/COC-003877'", "'Valid'", "'No'", "datetime'2027-11-07T00:00:00'", "'Novelteak Nicaragua S. A.'", "'Certificate holder'", "'Valid'", null, "'NICARAGUA'"]
]
}
}
},
"Version": 1
},
"ExecutionMetricsKind": 1
}
}]
},
"QueryId": ""
}],
"cancelQueries": [],
"modelId": 4930701
}The interesting data from us really is on the bottom in the "RestartTokens" JSON field. That's the only parameter that changes between requests. It's content is always the data of the last returned row.
It returns something like this:
{
"jobIds": ["184a86d4-b020-4137-a1d0-2168c96a6bd6"],
"results": [{
"jobId": "184a86d4-b020-4137-a1d0-2168c96a6bd6",
"result": {
"data": {
"timestamp": "2023-01-13T08:52:24.398Z",
"rootActivityId": "a6cbba1c-798b-4224-a657-864a15ca146a",
"descriptor": {
"Select": [{
"Kind": 1,
"Depth": 0,
"Value": "G6",
"GroupKeys": [{
"Source": {
"Entity": "Organization",
"Property": "Organization Name"
},
"Calc": "G6",
"IsSameAsSelect": true
}],
"Name": "Organization.Name"
}, {
"Kind": 1,
"Depth": 0,
"Value": "G0",
"GroupKeys": [{
"Source": {
"Entity": "Certificate",
"Property": "License"
},
"Calc": "G0",
"IsSameAsSelect": true
}],
"Name": "Certificate.License"
}, {
"Kind": 1,
"Depth": 0,
"Value": "G4",
"Format": "yyyy\\-MM\\-dd",
"GroupKeys": [{
"Source": {
"Entity": "Certificate",
"Property": "Date_From__c"
},
"Calc": "G4",
"IsSameAsSelect": true
}],
"Name": "Certificate.Date_From__c"
}, {
"Kind": 1,
"Depth": 0,
"Value": "G5",
"Format": "yyyy\\-MM\\-dd",
"GroupKeys": [{
"Source": {
"Entity": "Certificate",
"Property": "Date_To__c"
},
"Calc": "G5",
"IsSameAsSelect": true
}],
"Name": "Certificate.Date_To__c"
}, {
"Kind": 1,
"Depth": 0,
"Value": "G1",
"GroupKeys": [{
"Source": {
"Entity": "Certificate",
"Property": "Full_Certificate_Code__c"
},
"Calc": "G1",
"IsSameAsSelect": true
}],
"Name": "Certificate.Full_Certificate_Code__c"
}, {
"Kind": 1,
"Depth": 0,
"Value": "G10",
"GroupKeys": [{
"Source": {
"Entity": "Country Data",
"Property": "Country"
},
"Calc": "G10",
"IsSameAsSelect": true
}],
"Name": "Country Data.Country"
}, {
"Kind": 1,
"Depth": 0,
"Value": "G2",
"GroupKeys": [{
"Source": {
"Entity": "Certificate",
"Property": "status"
},
"Calc": "G2",
"IsSameAsSelect": true
}],
"Name": "Certificate.status"
}, {
"Kind": 1,
"Depth": 0,
"Value": "G7",
"GroupKeys": [{
"Source": {
"Entity": "Organization",
"Property": "Type (groups)"
},
"Calc": "G7",
"IsSameAsSelect": true
}],
"Name": "Organization.Type (groups)"
}, {
"Kind": 1,
"Depth": 0,
"Value": "G3",
"GroupKeys": [{
"Source": {
"Entity": "Certificate",
"Property": "CW"
},
"Calc": "G3",
"IsSameAsSelect": true
}],
"Name": "Certificate.CW"
}, {
"Kind": 1,
"Depth": 0,
"Value": "G9",
"GroupKeys": [{
"Source": {
"Entity": "Organization",
"Property": "State_County__c"
},
"Calc": "G9",
"IsSameAsSelect": true
}],
"Name": "Organization.State_County__c"
}, {
"Kind": 1,
"Depth": 0,
"Value": "G8",
"GroupKeys": [{
"Source": {
"Entity": "Organization",
"Property": "Site status"
},
"Calc": "G8",
"IsSameAsSelect": true
}],
"Name": "Organization.Site status"
}],
"Expressions": {
"Primary": {
"Groupings": [{
"Keys": [{
"Source": {
"Entity": "Certificate",
"Property": "License"
},
"Select": 1
}, {
"Source": {
"Entity": "Certificate",
"Property": "Full_Certificate_Code__c"
},
"Select": 4
}, {
"Source": {
"Entity": "Certificate",
"Property": "status"
},
"Select": 6
}, {
"Source": {
"Entity": "Certificate",
"Property": "CW"
},
"Select": 8
}, {
"Source": {
"Entity": "Certificate",
"Property": "Date_From__c"
},
"Select": 2
}, {
"Source": {
"Entity": "Certificate",
"Property": "Date_To__c"
},
"Select": 3
}, {
"Source": {
"Entity": "Organization",
"Property": "Organization Name"
},
"Select": 0
}, {
"Source": {
"Entity": "Organization",
"Property": "Type (groups)"
},
"Select": 7
}, {
"Source": {
"Entity": "Organization",
"Property": "Site status"
},
"Select": 10
}, {
"Source": {
"Entity": "Organization",
"Property": "State_County__c"
},
"Select": 9
}, {
"Source": {
"Entity": "Country Data",
"Property": "Country"
},
"Select": 5
}],
"Member": "DM0"
}]
}
},
"Version": 2
},
"metrics": {
"Version": "1.0.0",
"Events": [{
"Id": "13dede0d-d339-4487-943e-d260a5c2307c",
"Name": "Execute Semantic Query",
"Component": "DSE",
"Start": "2023-01-13T08:52:24.3989493Z",
"End": "2023-01-13T08:52:32.1594707Z"
}, {
"Id": "eff7947b-1f4b-4d3c-b038-11500638a626",
"ParentId": "13dede0d-d339-4487-943e-d260a5c2307c",
"Name": "Execute DAX Query",
"Component": "DSE",
"Start": "2023-01-13T08:52:24.4614498Z",
"End": "2023-01-13T08:52:32.1594707Z",
"Metrics": {
"RowCount": 501
}
}, {
"Id": "791D47FC-F8EC-45E0-9AAA-18767DCAED79",
"ParentId": "eff7947b-1f4b-4d3c-b038-11500638a626",
"Name": "Execute Query",
"Component": "AS",
"Start": "2023-01-13T08:52:24.933Z",
"End": "2023-01-13T08:52:32.037Z"
}, {
"Id": "79A2F1C6-F3AD-42B3-A7BF-5945AB9F2208",
"ParentId": "791D47FC-F8EC-45E0-9AAA-18767DCAED79",
"Name": "Serialize Rowset",
"Component": "AS",
"Start": "2023-01-13T08:52:32.033Z",
"End": "2023-01-13T08:52:32.037Z"
}]
},
"fromCache": false,
"dsr": {
"Version": 2,
"MinorVersion": 1,
"DS": [{
"N": "DS0",
"PH": [{
"DM0": [{
"RF": 1,
"S": [{
"N": "G0",
"T": 1,
"DN": "D0"
}, {
"N": "G1",
"T": 1,
"DN": "D1"
}, {
"N": "G2",
"T": 1,
"DN": "D2"
}, {
"N": "G3",
"T": 1,
"DN": "D3"
}, {
"N": "G4",
"T": 7
}, {
"N": "G5",
"T": 7
}, {
"N": "G6",
"T": 1,
"DN": "D4"
}, {
"N": "G7",
"T": 1,
"DN": "D5"
}, {
"N": "G8",
"T": 1,
"DN": "D6"
}, {
"N": "G9",
"T": 1,
"DN": "D7"
}, {
"N": "G10",
"T": 1,
"DN": "D8"
}],
"C": [0, 0, 0, 0, 1674518400000, 1832198400000, 0, 0, 0, 0, 0]
}, {
"C": [1, 1, 1, 1, 1],
"R": 444
}, {
"C": [2, 2, 2, 2],
"R": 444,
"Ø": 512
}, {
"C": [3, 3, 1674432000000, 1832112000000, 3, 2, 3],
"R": 396
}, {
"C": [4, 4, 4, 1, 3, 4],
"R": 188
}, {
"C": [5, 5, 5, 0, 4, 5],
"R": 188
}, {
"C": [6, 6, 6, 1, 5, 3],
"R": 316
}, {
"C": [7],
"R": 1983
}, {
"C": [8, 6],
"R": 1471
}, {
"C": [9, 7],
"R": 1471
}, {
"C": [10, 8],
"R": 1471
}, {
"C": [11, 0, 9],
"R": 1343
}, {
"C": [12, 1],
"R": 1855
}, {
"C": [7, 7, 1674345600000, 1832025600000, 13, 0, 10, 6],
"R": 268
}, {
"C": [8, 8, 1689897600000, 14, 11, 7],
"R": 412
}, {
"C": [9, 9, 1832025600000, 15, 1, 8],
"R": 156,
"Ø": 512
}, {
"C": [10, 10, 1800489600000, 16, 0, 12, 9],
"R": 156
}, {
"C": [11, 11, 1832025600000, 17, 13, 0],
"R": 412
}, {
"C": [12, 12, 18, 6],
"R": 444,
"Ø": 512
}, {
"C": [13, 13, 1674259200000, 1832112000000, 19, 14, 8],
"R": 396
}, {
"C": [14, 14, 1831939200000, 20, 8, 3],
"R": 412
}, {
"C": [21, 1],
"R": 1855
}, {
"C": [22],
"R": 1983
}, {
"C": [23],
"R": 1983
}, {
"C": [24],
"R": 1983
}, {
"C": [15, 15, 25, 15],
"R": 1468
}, {
"C": [26],
"R": 1983
}, {
"C": [27, 0],
"R": 1855
}, {
"C": [28, 1],
"R": 1855
}, {
"C": [16, 16, 29, 0, 6],
"R": 316,
"Ø": 512
}, {
"C": [17, 17, 30, 10],
"R": 956
}, {
"C": [18, 18, 31, 16, 0],
"R": 444
}, {
"C": [19, 19, 1674172800000, 1831852800000, 32, 6],
"R": 396,
"Ø": 512
}, {
"C": [20, 20, 1674086400000, 1831766400000, 33, 11],
"R": 908
}, {
"C": [21, 21, 34, 17, 6],
"R": 444
}, {
"C": [22, 22, 35, 18, 0],
"R": 444
}, {
"C": [23, 23, 1674000000000, 1831680000000, 36, 19, 12],
"R": 396
}, {
"C": [24, 24, 37, 8],
"R": 444,
"Ø": 512
}, {
"C": [25, 25, 38, 13],
"R": 956
}, {
"C": [26, 26, 39, 14],
"R": 956
}, {
"C": [27, 27, 1797897600000, 40, 20, 0],
"R": 412
}, {
"C": [28, 28, 1673913600000, 1831593600000, 41, 6],
"R": 396,
"Ø": 512
}, {
"C": [29, 29, 42, 15],
"R": 956
}, {
"C": [30, 30, 43, 21, 9],
"R": 444
}, {
"C": [31, 31, 1815696000000, 44, 1, 22, 6],
"R": 284
}, {
"C": [45],
"R": 1983
}, {
"C": [46],
"R": 1983
}, {
"C": [47],
"R": 1983
}, {
"C": [48, 0],
"R": 1855
}, {
"C": [49, 1],
"R": 1855
}, {
"C": [50, 23],
"R": 1471
}, {
"C": [32, 32, 1831593600000, 51, 0, 2],
"R": 284,
"Ø": 512
}, {
"C": [33, 33, 52],
"R": 1980
}, {
"C": [34, 34, 53, 16],
"R": 956
}, {
"C": [35, 35, 54, 24, 6],
"R": 444
}, {
"C": [36, 36, 1673827200000, 1831507200000, 55, 17],
"R": 396,
"Ø": 512
}, {
"C": [37, 37, 56, 25, 7],
"R": 444
}, {
"C": [38, 38, 57, 5, 3],
"R": 444
}, {
"C": [39, 39, 58, 26],
"R": 1468
}, {
"C": [40, 40, 59, 14],
"R": 444,
"Ø": 512
}, {
"C": [41, 41, 1829606400000, 60, 1, 18],
"R": 796
}, {
"C": [61, 0],
"R": 1855
}, {
"C": [62, 1],
"R": 1855
}, {
"C": [63],
"R": 1983
}, {
"C": [42, 42, 1831507200000, 64, 0, 19],
"R": 796
}, {
"C": [43, 43, 65],
"R": 1980
}, {
"C": [44, 44, 1673740800000, 1831420800000, 66, 1, 27, 20],
"R": 268
}, {
"C": [67, 28],
"R": 1471
}, {
"C": [68, 29],
"R": 1471
}, {
"C": [69, 0],
"R": 1855
}, {
"C": [45, 45, 70, 30, 21],
"R": 444
}, {
"C": [46, 46, 1, 71, 2],
"R": 436,
"Ø": 512
}, {
"C": [47, 47, 0, 72, 17, 6],
"R": 436
}, {
"C": [48, 48, 73, 2],
"R": 444,
"Ø": 512
}, {
"C": [49, 49, 74, 31, 6],
"R": 444
}, {
"C": [50, 50, 1673654400000, 1831334400000, 75, 22],
"R": 396,
"Ø": 512
}, {
"C": [51, 51, 1, 76, 1, 23],
"R": 820
}, {
"C": [77, 0],
"R": 1855
}, {
"C": [78, 1],
"R": 1855
}, {
"C": [52, 52, 0, 79, 0, 32, 0],
"R": 308
}, {
"C": [53, 53, 80, 4, 5],
"R": 444
}, {
"C": [54, 54, 81, 33, 0],
"R": 444
}, {
"C": [55, 55, 1673568000000, 1686614400000, 82, 34, 3],
"R": 396
}, {
"C": [56, 56, 1860192000000, 83, 28, 20],
"R": 412
}, {
"C": [57, 57, 1831248000000, 84, 35, 0],
"R": 412
}, {
"C": [58, 58, 1, 85, 1, 3, 4],
"R": 308
}, {
"C": [86],
"R": 1983
}, {
"C": [87, 0],
"R": 1855
}, {
"C": [88, 1, 36, 12],
"R": 319
}, {
"C": [37],
"R": 1535
}, {
"C": [38],
"R": 1535
}, {
"C": [89, 3, 4],
"R": 447
}, {
"C": [90],
"R": 1983
}, {
"C": [91],
"R": 1983
}, {
"C": [92],
"R": 1983
}, {
"C": [93],
"R": 1983
}, {
"C": [94],
"R": 1983
}, {
"C": [95, 39],
"R": 1471
}, {
"C": [96, 3],
"R": 1471
}, {
"C": [97],
"R": 1983
}, {
"C": [98],
"R": 1983
}, {
"C": [99],
"R": 1983
}, {
"C": ["Resolute FP Canada Inc., Gatineau Paper Mill"],
"R": 1983
}, {
"C": ["Resolute FP Canada Inc., Kénogami Paper Mill"],
"R": 1983
}, {
"C": ["Resolute FP Canada Inc., La Doré sawmill"],
"R": 1983
}, {
"C": ["Resolute FP Canada Inc., Maniwaki sawmill"],
"R": 1983
}, {
"C": ["Resolute FP Canada Inc., Mistassini sawmill"],
"R": 1983
}, {
"C": ["Resolute FP Canada Inc., Outardes sawmill"],
"R": 1983
}, {
"C": ["Resolute FP Canada Inc., Saint Thomas sawmill"],
"R": 1983
}, {
"C": ["Resolute FP Canada Inc., Saint-Félicien Sawmill"],
"R": 1983
}, {
"C": ["Resolute FP Canada Inc., Senneterre sawmill"],
"R": 1983
}, {
"C": ["Resolute FP US Inc., Bureau des ventes Pates et papier (Sales Office US)", 40, 12],
"R": 447
}, {
"C": ["Resolute Growh Canada Inc., Atikokan sawmill", 39, 4],
"R": 447
}, {
"C": ["Resolute Growth Canada Inc, Ignace sawmill"],
"R": 1983
}, {
"C": ["Resolute Growth Canada Inc., Thunder Bay Sawmill"],
"R": 1983
}, {
"C": ["Société en Commandite Scierie Opitciwan, Opitciwan Sawmill", 3],
"R": 1471
}, {
"C": [59, 59, 0, "Shanghai Kinglos Musical Instruments Co., Ltd", 0, 6],
"R": 308,
"Ø": 512
}, {
"C": [60, 60, "Bloomage Biotechnology Corporation Limited", 41],
"R": 1468
}, {
"C": [61, 61, 1673481600000, 1831161600000, "Cisco Brothers Corporation", 42, 12],
"R": 396
}, {
"C": [62, 62, 1832198400000, "Oldenboom Doetinchem", 1, 18],
"R": 284,
"Ø": 512
}, {
"C": ["Oldenboom Groep B.V.", 0],
"R": 1855
}, {
"C": ["Oldenboom Meinesz", 1],
"R": 1855
}, {
"C": [63, 63, 1797638400000, "Tranceria del TRONTO S.r.l.", 0, 43, 0],
"R": 284
}, {
"C": [64, 64, 1705363200000, "CIOTTI COMPENSATI S.r.l.", 35],
"R": 1436
}, {
"C": [65, 65, 1764115200000, "GABI CIOCAN COM SRL", 24],
"R": 412,
"Ø": 512
}, {
"C": [66, 66, 1769299200000, "TREA DI TREMOLADA MAURO &C. S.A.S.", 44, 0],
"R": 412
}, {
"C": [67, 67, 1, 1831161600000, "Highland Pellets, LLC", 45, 12],
"R": 404
}, {
"C": [68, 68, 0, "MBA Group Ltd", 7],
"R": 436,
"Ø": 512
}, {
"C": [69, 69, "Iwakura Printing Co., Ltd.", 2, 3],
"R": 444
}, {
"C": [70, 70, "HUBEI LONGCHEN GREENTECH CO., LTD.", 46, 6],
"R": 444
}, {
"C": [71, 71, 1, "Forestal Andes Ltda", 25],
"R": 436,
"Ø": 512
}, {
"C": ["Servicios y Comercialización Forestal Ltda (SERCOFOR)", 1],
"R": 1855
}, {
"C": [72, 72, 0, 1693958400000, "MRS KAĞIT KARTON SAN. ve TİC. LTD.ŞTİ.", 0, 47, 26],
"R": 276
}, {
"C": [73, 73, 1705104000000, "WORKSHOP DOORS SRL", 48, 24],
"R": 412
}, {
"C": [74, 74, 1733184000000, "Narain Labels (India) Pvt. Ltd", 27],
"R": 412,
"Ø": 512
}, {
"C": [75, 75, 1831161600000, "SS PRINTERS", 49, 28],
"R": 412
}, {
"C": [76, 76, 1788134400000, "BALORMAN ROMANIA SRL", 48, 24],
"R": 412
}, {
"C": [77, 77, 1797292800000, "DeART SRL", 50, 0],
"R": 412
}, {
"C": [78, 78, 1804550400000, "Suzhou Secon Packing Material Co., Ltd", 51, 6],
"R": 412
}, {
"C": [79, 79, 1831161600000, "ITALIAN SEDIOLITI SRL", 52, 0],
"R": 412
}, {
"C": [80, 80, "IDALEN SA", 29],
"R": 444,
"Ø": 512
}, {
"C": [81, 81, "LOYAL TEXTILE MILLS LTD", 27],
"R": 956
}, {
"C": [82, 82, "Lattina & EL TETE", 53, 30],
"R": 444
}, {
"C": ["Lattina SRL dba El Tete SA"],
"R": 1983
}, {
"C": [83, 83, "BEAUTY CHOICES (HK) LIMITED", 6],
"R": 444,
"Ø": 512
}, {
"C": [84, 84, "Ningbo Better Brush Co.,Ltd.", 17],
"R": 1468
}, {
"C": [85, 85, "Kiev Wood LLC", 54, 31],
"R": 444
}, {
"C": [86, 86, "T-Champion Enterprise Co., Ltd.", 55, 6],
"R": 444
}, {
"C": [87, 87, "Jäger Gestellbau s.r.o.", 13],
"R": 444,
"Ø": 512
}, {
"C": [88, 88, "Zhejiang Jishan Printing & Dyeing Co., Ltd.", 6],
"R": 956
}, {
"C": [89, 89, "3M Label Limited", 49, 28],
"R": 444
}, {
"C": [90, 90, "Guangxi Zhongtou Wood Industry Ltd.", 23, 6],
"R": 444
}, {
"C": [91, 91, "CATARINA CADERNOS LTDA", 56, 32],
"R": 444
}, {
"C": [92, 92, "C & L IMPRESSOS GRAFICOS EM GERAL LTDA", 57],
"R": 1468
}, {
"C": [93, 93, "Fuyang Zhongyuan Packaging Co., Ltd", 58, 6],
"R": 444
}, {
"C": [94, 94, "KİPAŞ MENSUCAT İŞLETMELERİ ANONİM ŞİRKETİ", 26],
"R": 444,
"Ø": 512
}, {
"C": [95, 95, "BABET KAGITCILIK VE AMBALAJ MALZEMELERI ITHALAT IHRACAT SAN. VE TIC. A.S."],
"R": 1980
}, {
"C": [96, 96, 1, 1673395200000, 1831075200000, "Veracel Celulose S.A", 59, 32],
"R": 388
}, {
"C": [97, 97, 0, 1683936000000, "International Paper & Sun Cartonboard Co., Ltd.", 6],
"R": 404,
"Ø": 512
}, {
"C": [98, 98, 1831075200000, "Effingermedien AG", 1, 60, 20],
"R": 284
}, {
"C": ["OSCARDS AG", 29],
"R": 1471
}, {
"C": ["Schellenberg Cartonagen AG"],
"R": 1983
}, {
"C": ["Schellenberg Druck AG", 0],
"R": 1855
}, {
"C": ["Schellenberg Druck AG Zürich", 1],
"R": 1855
}, {
"C": ["Schwegler Druck und Medien AG"],
"R": 1983
}, {
"C": [99, 99, 1830384000000, "Joos Connect NV", 33],
"R": 412,
"Ø": 512
}, {
"C": ["Joos NV", 0],
"R": 1855
}, {
"C": ["Joos Print NV", 1],
"R": 1855
}, {
"C": ["Speciaaldrukkerij Joos NV", 18],
"R": 959
}, {
"C": ["FSC-C011538", "NC-COC-002894", 1831075200000, "M & R International, Inc.", 0, 61, 12],
"R": 284
}, {
"C": ["FSC-C019126", "CU-COC-812569", 1717459200000, "TURNOWSKY LTD", 34],
"R": 412,
"Ø": 512
}, {
"C": ["FSC-C019883", "RINA-COC-001961", 1700784000000, "PPHU LIMBA Ryszard Majewski i Tomasz Szerel Spółka Jawna", 62, 8],
"R": 412
}, {
"C": ["FSC-C022435", "SGSHK-COC-006328", 1718064000000, "JUKEN SANGYO (PHILS.) CORPORATION", 63, 35],
"R": 412
}, {
"C": ["FSC-C103868", "ICILA-COC-000448", 1766188800000, "MODUL-PAN S.r.l.", 64, 0],
"R": 412
}, {
"C": ["FSC-C106063", "TUVDC-COC-100662", 1778371200000, "SPONGO.de GmbH", 22],
"R": 412,
"Ø": 512
}, {
"C": ["FSC-C107961", "SGSHK-COC-009041", 1791072000000, "The Phoenix Press Sdn. Bhd.", 65, 10],
"R": 412
}, {
"C": ["FSC-C113407", "SCS-COC-006367", 1831161600000, "Burden Furniture Co., Ltd.", 66, 2],
"R": 412
}, {
"C": [1, 67],
"R": 1407
}, {
"C": ["Calvary Furniture Ltd.", 68, 36],
"R": 447
}, {
"C": ["Gia An Loc One Member Limited Liability Company", 69, 2],
"R": 447
}, {
"C": ["Song Nghi Trading Manufacture Only Member Company Limited", 66],
"R": 1471
}, {
"C": ["Viet Duc Wood Processing Co., Ltd.", 70],
"R": 1471
}, {
"C": ["FSC-C114048", "SCS-COC-004389", 1831075200000, "Polpro Sp. z o.o.", 0, 71, 8],
"R": 284
}, {
"C": ["FSC-C114335", "SA-COC-003859", "OWI Zala Bt.", 72, 37],
"R": 444
}, {
"C": ["FSC-C114341", "SA-COC-003862", "Merthyr Tydfil Institute for the Blind", 7],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C114351", "DNV-COC-000588", "CARTIERA DI NEBBIUNO S.R.L.", 0],
"R": 956
}, {
"C": ["FSC-C118671", "TUVDC-COC-888483", 1697932800000, "M&R International Inc., Shanghai", 73, 6],
"R": 412
}, {
"C": ["FSC-C118749", "SGSCH-COC-010037", 1698364800000, "ROMCARTON S.A.", 74, 24],
"R": 412
}, {
"C": ["FSC-C121820", "IMA-FM/COC-007329", 1831075200000, "LNG Indústria e Comércio de Madeiras Ltda. - Uberlandia", 75, 32],
"R": 412
}, {
"C": ["FSC-C125687", "SGSCH-COC-010230", 1738108800000, "QUATTRO PAVIMENTE TEHNICE SRL", 76, 24],
"R": 412
}, {
"C": ["FSC-C128767", "ICILA-COC-002955", 1769472000000, "PENNELLIFICIO 2000 SRL", 77, 0],
"R": 412
}, {
"C": ["FSC-C130456", "BV-COC-130456", 1831075200000, "VANPORT INTERNATIONAL, INC.", 78, 12],
"R": 412
}, {
"C": ["FSC-C132501", "SGSCH-FM/COC-010837", 1791504000000, "Dare Wood Industrial (Maoming) Co., Ltd.", 55, 6],
"R": 412
}, {
"C": ["FSC-C138695", "BV-COC-138695", 1831075200000, "BLUE ROOTS LIMITED", 10],
"R": 412,
"Ø": 512
}, {
"C": ["FSC-C139029", "NC-COC-029300", "Kuipers Bouwmaterialen Denekamp B.V.", 1, 18],
"R": 828
}, {
"C": ["Kuipers Bouwmaterialen Emmen B.V."],
"R": 1983
}, {
"C": ["Kuipers Bouwmaterialen en Steenhandel BV", 0],
"R": 1855
}, {
"C": ["Kuipers Bouwmaterialen Hardenberg B.V.", 1],
"R": 1855
}, {
"C": ["Kuipers Bouwmaterialen Veendam B.V."],
"R": 1983
}, {
"C": ["Kuipers Bouwmaterialen Wolvega B.V."],
"R": 1983
}, {
"C": ["Kuipers Bouwmaterialen Zwolle B.V."],
"R": 1983
}, {
"C": ["Kuipers Prefab Bouwsystemen B.V."],
"R": 1983
}, {
"C": ["FSC-C139108", "NC-COC-030856", "LLC \"LISPROM-GRUP\"", 0, 31],
"R": 828
}, {
"C": ["FSC-C139212", "TT-COC-006430", "P&S Partners Tomasz Sydow", 8],
"R": 956
}, {
"C": ["FSC-C139215", "SGSCH-COC-011193", "Valentić, zajednički obrt za prijevoz, trgovinu i proizvodnju", 38],
"R": 956
}, {
"C": ["FSC-C139216", "RR-COC-000209", "Liting Universal (Zhejiang) Electric Corp.", 6],
"R": 956
}, {
"C": ["FSC-C139217", "SGSCH-COC-011194", "Kovačić stolarija, obrt za proizvodnju vl. Zdravko Kovačić", 38],
"R": 956
}, {
"C": ["FSC-C139223", "SGSHK-COC-330428", "Dongguan City Renyi Paper Co., Ltd.", 6],
"R": 956
}, {
"C": ["FSC-C139258", "SCS-COC-006195", "Envases Food Solutions SAU dba Envases Del Plata SA- Envases Tinplate SAU", 79, 30],
"R": 444
}, {
"C": ["FSC-C139282", "SGSCH-COC-070263", "Unifoil Sp. z o.o.", 8],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C139309", "SAI-COC-002853", "Linhai Boli-far Lighting-Producing Co.,Ltd.", 6],
"R": 956
}, {
"C": ["FSC-C145836", "ICILA-COC-004068", 1704758400000, "SCATOLIFICIO RINASCENTE SRL", 80, 0],
"R": 412
}, {
"C": ["FSC-C146089", "SGSCH-FM/COC-011486", 1705708800000, "State enterprise “Slovechno Forest Enterprise” of Zhytomyr Regional Forestry and Hunting Board", 81, 31],
"R": 412
}, {
"C": ["FSC-C147779", "GFA-COC-006869", 1831075200000, "Shenzhen Hongrunhe Paper Technology Co., Ltd.", 6],
"R": 412,
"Ø": 512
}, {
"C": ["FSC-C147789", "APCER-COC-150660", 1712707200000, "LACABLEX, S.L.", 9],
"R": 924
}, {
"C": ["FSC-C150512", "APCER-COC-150683", 1722384000000, "JPZ Cartonagem, Lda.", 39],
"R": 924
}, {
"C": ["FSC-C152164", "RINA-COC-000728", 1728777600000, "Warter Spółka Jawna Oddział Tarnówka", 82, 8],
"R": 412
}, {
"C": ["FSC-C152939", "RINA-COC-000774", 1731369600000, "Przetwórstwo Drewna Kalla Sp. z o.o.", 83],
"R": 1436
}, {
"C": ["FSC-C160445", "RINA-COC-000764", 1759017600000, "JOPPOL Sp. z o.o.", 84],
"R": 1436
}, {
"C": ["FSC-C161320", "APCER-COC-150808", 1762128000000, "Tipografia Santos & Marques, Lda (RioGráfica)", 39],
"R": 412,
"Ø": 512
}, {
"C": ["FSC-C169418", "SGSCH-COC-230031", 1785888000000, "DAP WOOD LtD", 85, 31],
"R": 412
}, {
"C": ["FSC-C170348", "CQ-COC-000598", 1788825600000, "A.P.A. HOLZ UG", 86, 22],
"R": 412
}, {
"C": ["FSC-C170968", "CQ-COC-000601", 1791072000000, "ALESSANDRONI ALESSANDRO FALEGNAMERIA ARTIGIANALE", 87, 0],
"R": 412
}, {
"C": ["FSC-C183683", "TSUD-COC-002143", 1831075200000, "GIRIRAJ PACKAGING", 88, 27],
"R": 412
}, {
"C": ["FSC-C183919", "CU-COC-891980", "Martens van Wezel Kartonnages B.V.", 18],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C184023", "SGSCH-COC-830016", "LITORAL SHIP SERVICE S.A.", 30],
"R": 956
}, {
"C": ["FSC-C184084", "ESTS-COC-222295", "Guangzhou Orit Industry Co., Ltd", 55, 6],
"R": 444
}, {
"C": ["FSC-C184203", "SA-COC-013623", "Hestia Doors OÜ", 11],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C184356", "GFA-COC-006860", "Dietmar Diebold Druck & Direktmarketing", 22],
"R": 956
}, {
"C": ["FSC-C184405", "NC-COC-071155", "Chang Hong Packaging Co., LTD.", 14],
"R": 956
}, {
"C": ["FSC-C184569", "CU-COC-892509", "ADVANS - Spas Kostadinov OOD", 40],
"R": 956
}, {
"C": ["FSC-C184703", "SA-COC-013659", "Anji Jujiu Furniture Co., Ltd", 89, 6],
"R": 444
}, {
"C": ["FSC-C184859", "SA-COC-013676", "ZD ORMAN ÜRÜNLERİ SANAYİ VE TİCARET LİMİTED ŞİRKETİ", 26],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C184887", "BV-COC-184887", "Bluejet sp. z o.o.", 8],
"R": 956
}, {
"C": ["FSC-C184891", "TUVDC-COC-101291", 1857427200000, "TAKWOA Accessories", 28],
"R": 924
}, {
"C": ["FSC-C184944", "DNV-COC-002558", 1831075200000, "Pack Planet Private Limited", 90, 27],
"R": 412
}, {
"C": ["FSC-C184950", "ICILA-COC-004515", "TREVO SRL", 35, 0],
"R": 444
}, {
"C": ["FSC-C185117", "INT-COC-001714", "Beyond Group Srl", 91],
"R": 1468
}, {
"C": ["FSC-C185134", "SCS-COC-009588", "MX FLORESTAL LTDA", 92, 32],
"R": 444
}, {
"C": ["FSC-C185223", "BV-COC-185223", "QUANZHOU VIITION GIFTS CO., LTD", 93, 6],
"R": 444
}, {
"C": ["FSC-C185325", "TSUD-COC-002206", "HUNG DIEU ONE MEMBER COMPANY LIMITED", 66, 2],
"R": 444
}, {
"C": ["FSC-C185350", "GFA-COC-006945", "Tongxiang Fenghui Packaging Co., Ltd.", 6],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C185489", "GFA-COC-006966", "Dongguan Huayi Stationery Leather Co., Ltd"],
"R": 1980
}, {
"C": ["FSC-C185504", "DNV-COC-002570", "KIEN LONG PACKAGING MANUFACTURING TRADING COMPANY LIMITED", 66, 2],
"R": 444
}, {
"C": ["FSC-C185611", "TSUD-COC-002215", "AN VIET IMPORT EXPORT SERVICES TRADING MANUFACTURING CORPORATION"],
"R": 1468,
"Ø": 512
}, {
"C": ["FSC-C185772", "SQS-COC-500122", "C.T.C. S.r.l.", 0],
"R": 956
}, {
"C": ["FSC-C185799", "TSUD-COC-002148", "Eximcorp India Pvt Ltd", 27],
"R": 956
}, {
"C": [1],
"R": 1919
}, {
"C": ["Eximcorp India Pvt Ltd."],
"R": 1983
}, {
"C": ["FSC-C002022", "SA-COC-001220", 1673308800000, 1830988800000, "Daishinsha Inc.", 0, 2, 3],
"R": 268
}, {
"C": ["FSC-C002795", "NC-COC-012296", "Livonia Print SIA", 41],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C003450", "SGSCH-COC-001256", "Fiberdeck SARL", 1, 42],
"R": 828
}, {
"C": ["Handelsonderneming van Felix Clercx B.V.", 0, 18],
"R": 831
}, {
"C": ["FSC-C010988", "SGSHK-COC-001955", 1733443200000, "Zhejiang Nengfu Tourist Products Co., Ltd.", 17, 6],
"R": 412
}, {
"C": ["FSC-C012831", "SGSHK-COC-005635", 1830988800000, "ZHEJIANG TONA HOME CO., LTD."],
"R": 1948
}, {
"C": ["FSC-C020218", "SGSHK-COC-005729", 1705622400000, "Foshan Sansico Printing & Packaging Co., Ltd."],
"R": 1436,
"Ø": 512
}, {
"C": ["FSC-C020799", "INT-COC-002201", 1830988800000, "Anglian Timber Ltd", 94, 7],
"R": 412
}, {
"C": ["FSC-C022668", "APCER-COC-150048", 1727481600000, "Costa Guerreiro, Lda.", 39],
"R": 412,
"Ø": 512
}, {
"C": ["Errelabels – España SL", 1, 9],
"R": 831
}, {
"C": ["FSC-C102749", "SGSCH-COC-003854", 1830988800000, "Professional Distribution Center", 0, 95, 12],
"R": 284
}, {
"C": ["FSC-C102810", "SGSCH-COC-002332", 1762300800000, "Imprimerie L’Empreinte inc.", 96, 4],
"R": 412
}, {
"C": ["FSC-C102992", "SGSCH-COC-003913", 1825891200000, "Paradigm Printing, Inc.", 97, 12],
"R": 412
}, {
"C": ["FSC-C108778", "ICILA-COC-002130", 1796428800000, "LEMA S.p.A.", 98, 0],
"R": 412
}, {
"C": ["FSC-C113678", "CU-COC-824351", 1830988800000, "1stinrail Limited", 7],
"R": 412,
"Ø": 512
}, {
"C": ["FSC-C114323", "SCS-COC-004465", "Dallas Door & Supply Co.", 99, 12],
"R": 444
}, {
"C": ["FSC-C114338", "FCBA-COC-000352", "GUYENNE PAPIER", 1, 42],
"R": 188,
"Ø": 512
}, {
"C": ["FSC-C114356", "ICILA-COC-002434", "PRINCO GRUP S.A.", 0, 24],
"R": 700
}, {
"C": ["FSC-C114389", "SA-COC-013057", "Linhai Tong Yu Crafts Co., Ltd.", 17, 6],
"R": 444
}, {
"C": ["Zhejiang asia export and import co. ltd", 1],
"R": 1855
}, {
"C": ["FSC-C114649", "TT-COC-004364", "UK Envelope Centre Ltd", 0, 25, 7],
"R": 316
}, {
"C": ["FSC-C115036", "SGSHK-COC-010863", 1, 1676505600000, "SHAIYO AA VIETNAM CO., LTD", 2],
"R": 404,
"Ø": 512
}, {
"C": ["FSC-C127708", "SGSCH-COC-000446", 0, 1761609600000, "Billerud Commercial LLC", "Florida", 12],
"R": 404
}, {
"C": ["FSC-C128484", "TUVDC-COC-888115", 1767657600000, "Shantou Nanheng Industrial Co.,Ltd", 6],
"R": 412,
"Ø": 512
}, {
"C": ["FSC-C131951", "RINA-COC-000151", 1786406400000, "Sinc Novation d.o.o.", 16],
"R": 924
}, {
"C": ["FSC-C132579", "SGSCH-COC-110028", 1792195200000, "DODY PLAST", "Vienne", 42],
"R": 412
}, {
"C": ["FSC-C135435", "SGSHK-COC-350153", 1810512000000, "CHIBA", 1, 15, 3],
"R": 284
}, {
"C": ["DLS-KOMAKI Co.,Ltd", 5],
"R": 1471
}, {
"C": ["East Japan Logistics Center", "Saitama"],
"R": 1471
}, {
"C": ["Fukuoka", 6],
"R": 1471
}, {
"C": ["HACHIOJI", 8],
"R": 1471
}, {
"C": ["HIROSHIMA", "Hiroshima"],
"R": 1471
}, {
"C": ["HYOGO", "Hyogo"],
"R": 1471
}, {
"C": ["IBARAKI", "Ibaraki"],
"R": 1471
}, {
"C": ["KANAGAWA", "Kanagawa"],
"R": 1471
}, {
"C": ["Kanazawa", 34],
"R": 1471
}, {
"C": ["KITAKAMI", "Iwate"],
"R": 1471
}, {
"C": ["KITAKANTO", "Tochigi"],
"R": 1471
}, {
"C": ["KONDO Printing Co., Ltd.", "Niigata"],
"R": 1471
}, {
"C": ["KYOTO", "Kyoto"],
"R": 1471
}, {
"C": ["MICHINOKU Printing Ltd.", "Iwate,"],
"R": 1471
}, {
"C": ["NAGAOKA", "Niigata"],
"R": 1471
}, {
"C": ["NAGOYA", 5],
"R": 1471
}, {
"C": ["OBARA Printing Ltd.", "Iwate"],
"R": 1471
}, {
"C": ["OMIYA", "Saitama"],
"R": 1471
}, {
"C": ["Osaka", 2],
"R": 1471
}, {
"C": ["SAPPORO", "Hokkaido"],
"R": 1471
}, {
"C": ["SATO CORPORATION", 0, 8],
"R": 1343
}, {
"C": ["SATO IMPRESS CO., LTD", 1, 15],
"R": 1343
}, {
"C": ["SENDAI", "Miyagi"],
"R": 1471
}, {
"C": ["Shizuoka", "Shizuoka"],
"R": 1471
}, {
"C": ["TAKAMATSU", "Kagawa"],
"R": 1471
}, {
"C": ["TAMACHI", 8],
"R": 1471
}, {
"C": ["West Japan Logistics Center", "Nara"],
"R": 1471
}, {
"C": ["FSC-C135903", "BV-COC-135903", 1830988800000, "SHANGHAI PEDDY CO., LTD.", 0, 6],
"R": 284,
"Ø": 512
}, {
"C": ["FSC-C136025", "BV-COC-136025", "CHANGXING JINLONG PAPER CO,. LTD"],
"R": 1980
}, {
"C": ["FSC-C138898", "CU-COC-855353", "Coral Tools Ltd", "Leeds", 7],
"R": 444
}, {
"C": ["FSC-C139107", "NC-COC-030209", "BCC AB", 21],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C139185", "NC-COC-030854", "PEMADO s.r.o.", 13],
"R": 956
}, {
"C": ["FSC-C139196", "INT-COC-001330", "Mardegan Legno Srl", 35, 0],
"R": 444
}, {
"C": ["FSC-C139211", "DNV-COC-001590", "Dongguan Xinyuanjia Environmental Technologies Co., Ltd.", "Guangdong", 6],
"R": 444
}, {
"C": ["FSC-C141406", "RINA-COC-002139", 1685318400000, "SUNIMPROF GmbH (storage)", 1, 22],
"R": 284,
"Ø": 512
}, {
"C": ["SUNIMPROF Nyomdaipari KFT (storage)", 37],
"R": 959
}, {
"C": ["Sunimprof Rottaprint S.R.L.", 0, "Cluj County", 24],
"R": 319
}, {
"C": ["SUNIMPROF ROTTAPRINT SRL (storage) Brasov", 1],
"R": 1343,
"Ø": 512
}, {
"C": ["SUNIMPROF ROTTAPRINT SRL (storage) Stefanestii de Jos"],
"R": 1983
}, {
"C": ["FSC-C145135", "SGSHK-COC-330613", 1701734400000, "Zhaoqing Contempary Beauty Creator Furnishing Co., Ltd.", 0, 6],
"R": 796
}, {
"C": ["FSC-C152225", "TUVDC-COC-101171", 1728950400000, "Resonance Paper Mill Pvt. Ltd.", "Dist. Morbi", 27],
"R": 412
}, {
"C": ["FSC-C154623", "TUVDC-COC-888196", 1736812800000, "Guangzhou Xinqicai Printing Co., Ltd.", "Zengcheng District", 6],
"R": 412
}, {
"C": ["FSC-C155755", "RR-COC-000937", 1741564800000, "Hong Kong Rui Sheng Yuan Limited", 36],
"R": 412,
"Ø": 512
}, {
"C": ["FSC-C160325", "GFA-COC-006714", 1830988800000, "ÇAĞRIM SERİGRAFİ ETİKET İNŞ. TEKS. SAN. VE TİC. LTD. ŞTİ.", "DENİZLİ", 26],
"R": 412
}, {
"C": ["FSC-C171378", "TUVDC-COC-888243", 1792454400000, "Jiangmen City Pengjiang District Tongxing Color Printing Co., Ltd.", 6],
"R": 412,
"Ø": 512
}, {
"C": ["FSC-C171549", "TUVDC-COC-888245", 1792972800000, "Jiangsu Jelt Lifting System Co., Ltd.", "JIANGSU PROVINCE"],
"R": 1436
}, {
"C": ["FSC-C183633", "ICILA-COC-004508", 1830988800000, "FREE BOX SRL", "PU", 0],
"R": 412
}, {
"C": ["FSC-C184426", "GFA-COC-006864", "PrintSafari.com GmbH", 22],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C184468", "ESTS-COC-222343", "Binh Thanh Printing Packaging Company Limited", 2],
"R": 956
}, {
"C": ["FSC-C184620", "SCS-COC-009535", "POLCOAT Sp. z o.o. sp.k", "-", 8],
"R": 444
}, {
"C": ["FSC-C184811", "BV-COC-184811", "ArtDruk Zakład Poligraficzny Andrzej Łuniewski"],
"R": 1468,
"Ø": 512
}, {
"C": ["FSC-C184922", "SA-COC-013682", "Wenzhou Zhibo Packaging Co., Ltd.", 17, 6],
"R": 444
}, {
"C": ["FSC-C184934", "BV-COC-184934", "Prominent Trading Pty Ltd", "VIC", 43],
"R": 444
}, {
"C": ["FSC-C184941", "NC-COC-068279", "Custodia Group S.R.L.", 24],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C184982", "BV-COC-184982", "DRUKARNIA \"GARBINO\" - KRZYSZTOF GARBINO", 8],
"R": 956
}, {
"C": ["FSC-C185016", "RINA-COC-002187", "Wai Shing Plastic Products (Hui Zhou) Co., Ltd.", 55, 6],
"R": 444
}, {
"C": ["FSC-C185035", "SCS-COC-009579", "ACP Industria Corrugadora SRL", "BA", 30],
"R": 444
}, {
"C": ["FSC-C185136", "RINA-COC-002188", "Shenzhen Xin He Paper Co., Ltd.", 6],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C185155", "RINA-COC-002189", "GUANG DONG ASUWANT PACKAGING CO.,LTD"],
"R": 1980
}, {
"C": ["FSC-C185201", "RINA-COC-002186", "Linhai Shuangchuang Carton Co., Ltd."],
"R": 1980
}, {
"C": ["FSC-C185285", "GFA-COC-006937", "Jiaxing Huacheng Packaging Materials Co., Ltd"],
"R": 1980
}, {
"C": ["FSC-C185297", "SA-COC-013715", "GİZA DİJİTAL OFSET AMBALAJ SANAYİ TİCARET LİMİTED ŞİRKETİ", 26],
"R": 956
}, {
"C": ["FSC-C185320", "SGSHK-COC-310874", "Hangzhou Donglong Packaging Co., Ltd", 6],
"R": 956
}, {
"C": ["FSC-C004242", "SA-COC-004383", 1673222400000, 1830902400000, "Marini Industria de Compensados Ltda", "Paraná", 32],
"R": 396
}, {
"C": ["FSC-C004651", "SCS-COC-001334", "Stone Publishing, Inc. dba Almaden", 42, 12],
"R": 444
}, {
"C": ["FSC-C007992", "INT-COC-001464", "Winter & Co (UK) Limited", 1, 7],
"R": 316,
"Ø": 512
}, {
"C": ["Winter & Company AG", 1, 20],
"R": 703
}, {
"C": ["Winter & Company AG Warehouse and Logistics (WWL)", 0],
"R": 1727
}, {
"C": ["Winter & Company BV", 1, "Netherlands", 18],
"R": 191
}, {
"C": ["Winter & Company GmbH", 22],
"R": 447,
"Ø": 512
}, {
"C": ["Winter & Company SAS", 42],
"R": 959
}, {
"C": ["Winter & Company UK Ltd", 0, "Cambridgeshire", 7],
"R": 319
}, {
"C": ["Winter Company Spain S.A.U.", 1, 9],
"R": 319,
"Ø": 512
}, {
"C": ["FSC-C009493", "DNV-COC-000551", "EKO-DREW Spółka z Ograniczoną Odpowiedzialnością Spółka Komandytowa", 0, 0, 8],
"R": 572
}, {
"C": ["FSC-C009503", "NC-COC-015374", 1, "Kontekss SIA", "Salas pagasts", 41],
"R": 436
}, {
"C": ["FSC-C010188", "INT-COC-002447", 0, "Arnold Laver & Co Ltd", "South Yorkshire", 7],
"R": 436
}, {
"C": [1],
"R": 1407,
"Ø": 512
}, {
"C": [94],
"R": 1535
}, {
"C": ["Tyne & Wear"],
"R": 1535
}, {
"C": ["Worcestershire"],
"R": 1535
}, {
"C": ["Arnold Laver & Co Ltd - Borehamwood", "Hertfordshire"],
"R": 1471
}, {
"C": ["Arnold Laver & Co. Ltd", "Stockton On Tees"],
"R": 1471
}, {
"C": ["West Midlands"],
"R": 1535
}, {
"C": ["Arnold Laver & Co. Ltd T/A Mosborough Call Collect", "South Yorkshire"],
"R": 1471
}, {
"C": ["Arnold Laver & Co. Ltd T/A Sheffiled Central Call Collect", "Sheffield"],
"R": 1471
}, {
"C": ["Arnold Laver & Co. Ltd.", "Berkshire"],
"R": 1471
}, {
"C": ["East Yorkshire"],
"R": 1535
}, {
"C": ["Greater Manchester"],
"R": 1535
}, {
"C": [25],
"R": 1535
}, {
"C": ["Arnold Laver Timber World", "Bucks"],
"R": 1471
}, {
"C": ["Cambridgeshire"],
"R": 1535
}, {
"C": ["London"],
"R": 1535
}, {
"C": ["Warwickshire"],
"R": 1535
}, {
"C": ["Hymor Timber", "Staffordshire"],
"R": 1471
}, {
"C": ["National Timber Systems"],
"R": 1471,
"Ø": 512
}, {
"C": ["National Timber Systems Catterick", "DL10 7HS"],
"R": 1471
}, {
"C": ["NY Timber - North Shields", "Tyne & Wear"],
"R": 1471
}, {
"C": ["NY Timber - Northallerton", "North Yorkshire"],
"R": 1471
}, {
"C": ["NY Timber - Sunderland"],
"R": 1471,
"Ø": 512
}, {
"C": ["FSC-C011161", "SCS-COC-001320", "Lithocraft Pty. Ltd.", 0, "VIC", 43],
"R": 316
}, {
"C": ["FSC-C012906", "NC-COC-002861", "Jointak Industrial Company Limited", 68, 6],
"R": 444
}, {
"C": ["FSC-C016339", "SGSCH-COC-001858", 1731110400000, "Neoperl AG / Diaqua AG", "Basel-Landschaft", 20],
"R": 412
}, {
"C": ["FSC-C018419", "SCS-COC-001314", 1830902400000, "Rutgers Printing & Packaging Solutions", "South Holland", 18],
"R": 412
}, {
"C": ["FSC-C095159", "SGSCH-COC-110088", 1679443200000, "Autajon CS", 1, 42],
"R": 284,
"Ø": 512
}, {
"C": ["Autajon Etiquette Méditerrannée"],
"R": 1983
}, {
"C": ["Autajon Labels Lorient"],
"R": 1983
}, {
"C": ["Autajon Labels S.A.U", "LA RIOJA", 9],
"R": 447
}, {
"C": ["AUTAJON Labels Sinel"],
"R": 1471,
"Ø": 512
}, {
"C": ["Autajon Labels Strasbourg", "67100", 42],
"R": 447
}, {
"C": ["Autajon Packaging Belgium SA", 33],
"R": 447,
"Ø": 512
}, {
"C": ["Autajon Packaging Boston", "NH", 12],
"R": 447
}, {
"C": ["Autajon Packaging Milano S.P.A", 91, 0],
"R": 447
}, {
"C": ["Autajon SP", 42],
"R": 447,
"Ø": 512
}, {
"C": ["Cartotecnica Tifernate S.P.A", "PERUGIA", 0],
"R": 447
}, {
"C": ["Chierese Pak S.R.L", "TO"],
"R": 1471
}, {
"C": ["Cultech Inc.", "NJ", 12],
"R": 447
}, {
"C": ["Durero Packaging SA", 12, 9],
"R": 447
}, {
"C": ["Eikon Centro Gráfico SA", 39],
"R": 447,
"Ø": 512
}, {
"C": ["Grafiche Seven S.P.A", "VR", 0],
"R": 447
}, {
"C": ["Groupe AUTAJON", 0, 42],
"R": 319,
"Ø": 512
}, {
"C": ["Haubtmann", 1],
"R": 1855
}, {
"C": ["Landerer GmbH & Co. KG", 22],
"R": 959
}, {
"C": ["O.G.A. S.r.l.", 80, 0],
"R": 447
}, {
"C": ["Säuberlin & Pfeiffer S.A", 20],
"R": 447,
"Ø": 512
}, {
"C": ["Thoro Packaging", "CA", 12],
"R": 447
}, {
"C": ["FSC-C100583", "SGSCH-COC-007959", 1, 1755302400000, "Akzenta Paneele & Profile", 1, 22],
"R": 148,
"Ø": 512
}, {
"C": ["Classen Holz Kontor GmbH", 0],
"R": 1727
}, {
"C": ["Classen Industries GmbH"],
"R": 1983
}, {
"C": ["Classen International GmbH"],
"R": 1983
}, {
"C": ["Classen Objekt & Design GmbH", 1],
"R": 1727
}, {
"C": ["Classen Vertriebs GmbH", 0],
"R": 1727
}, {
"C": ["Dispoline GmbH"],
"R": 1983
}, {
"C": ["Fiberboard GmbH"],
"R": 1983
}, {
"C": ["W. Classen GmbH & Co. KG", 0, "Rheinland-Pfalz"],
"R": 1343
}, {
"C": ["Wiparquet GmbH", 1],
"R": 1343,
"Ø": 512
}, {
"C": ["FSC-C109999", "SCS-COC-004099", 0, 1830902400000, "Evergreen International Limited", 0, 90, 27],
"R": 276
}, {
"C": [1, "Haryana"],
"R": 1407
}, {
"C": ["FSC-C114287", "ICILA-COC-002430", "CESAPLAST S.p.A.", 0, 44, 0],
"R": 316
}, {
"C": [1],
"R": 1919
}, {
"C": ["FSC-C114307", "DNV-COC-000586", "KABUS S.C.", 0, 8],
"R": 316,
"Ø": 512
}, {
"C": ["FSC-C114364", "SA-COC-008006", "Burnshield", 1, "Järvamaa", 11],
"R": 316
}, {
"C": ["Thermoarena OÜ", 0],
"R": 1855
}, {
"C": ["FSC-C114442", "TUVDC-COC-100782", "Max Bringmann KG", 22],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C115068", "TUEV-COC-000351", "Knappe + Lehbrink Promotion GmbH"],
"R": 1980
}, {
"C": ["FSC-C117389", "TUVDC-COC-100704", 1, 1685664000000, "Dickel-Holz GmbH & Co. KG"],
"R": 1940
}, {
"C": ["FSC-C119430", "SGSHK-COC-011581", 0, 1703203200000, "G.D. Enterprise Limited", 44],
"R": 916
}, {
"C": ["FSC-C119690", "CU-COC-818045", 1705622400000, "INFINYA LTD", 34],
"R": 924
}, {
"C": ["FSC-C124040", "SGSHK-COC-011670", 1736208000000, "Shandong Bihai Packaging Materials Co., Ltd.", 41, 6],
"R": 412
}, {
"C": ["FSC-C128851", "APCER-COC-150578", 1772668800000, "MADERAS CHIQUILLO, SL", 9],
"R": 412,
"Ø": 512
}, {
"C": ["FSC-C131088", "SGSHK-COC-330158", 1783382400000, "CENTURY REALTY LIMITED", 36],
"R": 924
}, {
"C": ["FSC-C132089", "SGSHK-COC-330193", 1789257600000, "TRANTEX PRODUCTS CO., LTD.", "GuangDong Province,", 6],
"R": 412
}, {
"C": ["FSC-C132502", "SGSCH-FM/COC-010836", 1791504000000, "Dare Wood Industrial (Zhaoqing) Co., Ltd.", 55],
"R": 1436
}, {
"C": ["Lu Xi", 1],
"R": 1343,
"Ø": 512
}, {
"C": ["Xian Jiangqing"],
"R": 1983
}, {
"C": ["Yu Gengsen"],
"R": 1983
}, {
"C": ["Zheng Guiqing"],
"R": 1983
}, {
"C": ["Zhongheng Forestry"],
"R": 1983
}, {
"C": ["FSC-C133368", "ICILA-COC-003031", 1797292800000, "DELMONTE SRL", 0, 44, 0],
"R": 284
}, {
"C": ["FSC-C137741", "GFA-COC-003119", 1830902400000, "WEROCA Kartonagen GmbH & Co. KG", 22],
"R": 412,
"Ø": 512
}, {
"C": ["FSC-C139176", "NC-COC-029620", "TRAWERS Sp. j.", 8],
"R": 956
}, {
"C": ["FSC-C139187", "SA-COC-006132", "MAGNUS SILVIS j.d.o.o.", 38],
"R": 956
}, {
"C": ["FSC-C139190", "SCS-COC-006184", "Coco Lumber, LLC", "North Carolina", 12],
"R": 444
}, {
"C": ["FSC-C139191", "AEN-COC-000731", "FUJIAN BAIFENG BAMBOO PRODUCTS CO., LTD", "Fujian Province", 6],
"R": 444
}, {
"C": ["FSC-C139219", "SGSHK-COC-320329", "Hangzhou Hengda Art & Culture Co., Ltd.", 89],
"R": 1468
}, {
"C": ["FSC-C139224", "SGSHK-COC-310166", "DALIAN GRACEHOME INTERNATIONAL TRADING CO., LTD."],
"R": 1468,
"Ø": 512
}, {
"C": ["FSC-C139231", "SGSHK-COC-320328", "BSM Enterprise Ltd."],
"R": 1980
}, {
"C": ["FSC-C139260", "RINA-COC-000839", "Tangshan Xingye Paper Products Co., Ltd."],
"R": 1980
}, {
"C": ["FSC-C139360", "SGSHK-COC-360038", "HSIN FONG INTERNATIONAL CO., LTD.", "Yunlin County", 14],
"R": 444
}, {
"C": ["HSIN FONG INTERNATIONAL CO.,LTD."],
"R": 1983
}, {
"C": ["FSC-C145477", "SGSHK-COC-320499", 1702771200000, "Jiangyin Xingke Paper Products Co., Ltd.", "JIANGSU PROVINCE", 6],
"R": 412
}, {
"C": ["FSC-C145749", "SGSCH-COC-050189", 1704499200000, "VOSS GmbH & Co. KG", "Schleswig-Holstein", 22],
"R": 412
}, {
"C": ["FSC-C152087", "SGSHK-COC-320640", 1728345600000, "Cixi Xinrui Printing Co., Ltd.", 17, 6],
"R": 412
}, {
"C": ["FSC-C153081", "RR-COC-000834", 1731888000000, "Ningbo Ouqi Smoking Set Co., Ltd"],
"R": 1436,
"Ø": 512
}, {
"C": ["FSC-C154380", "SGSHK-COC-320692", 1736121600000, "Changshu Changhong Textile Co., Ltd."],
"R": 1948
}, {
"C": ["FSC-C154518", "TAH-COC-002649", 1736208000000, "ETAP CO. FOR PAPER & BOARD ( S.A.E )", 45],
"R": 924
}, {
"C": ["FSC-C157558", "RR-COC-001405", 1748908800000, "Caoxian Smart Wooden Products Co.,Ltd.", 6],
"R": 924
}, {
"C": ["FSC-C159739", "SGSHK-COC-310410", 1756598400000, "Wenzhou Guohan Packing Co., Ltd."],
"R": 1948
}, {
"C": ["FSC-C163152", "SGSHK-COC-320852", 1767571200000, "Maratti Furniture Co., Ltd. Shanghai", 1],
"R": 1820
}, {
"C": ["Zhejiang Maratti Furniture Co., Ltd.", 0, "Zhejiang Province, P. R."],
"R": 1343
}, {
"C": ["FSC-C172045", "SGSHK-COC-310593", 1794528000000, "E-HOME FURNITURE CO., LTD.", "Guangdong Province, P.R."],
"R": 1436
}, {
"C": ["SUN GLORY LTD.", 1, 46],
"R": 319,
"Ø": 512
}, {
"C": ["FSC-C174153", "SGSCH-FM/COC-012060", 1814745600000, "Durafor Gie", 0, 29],
"R": 796
}, {
"C": ["FSC-C174225", "IMA-FM/COC-174225", 1830902400000, "Bernadete Brunhago", 1, 56, 32],
"R": 284
}, {
"C": ["Bruno Lalik", "Paraná"],
"R": 1471
}, {
"C": ["Claudinei Reisdorf", 56],
"R": 1471
}, {
"C": ["Dissenha Florestal Ltda.", 0, "Paraná"],
"R": 1343
}, {
"C": ["Fabrício Antônio Moreira Neto", 1, 56],
"R": 1343
}, {
"C": ["Lúcia Brunhago"],
"R": 1983
}, {
"C": ["Pedro Brunhago"],
"R": 1983
}, {
"C": ["Ravanello Agropecuária", "Paraná"],
"R": 1471
}, {
"C": ["FSC-C182464", "SA-COC-013479", "Nissho Co.,Ltd.", 0, 8, 3],
"R": 316
}, {
"C": ["FSC-C183028", "SCS-COC-009423", "PT Cipta Wijaya Mandiri", "JT", 1],
"R": 444
}, {
"C": ["FSC-C183193", "BV-COC-183193", "Denmark site", 1, 47],
"R": 316,
"Ø": 512
}, {
"C": ["Norway site", 48],
"R": 959
}, {
"C": ["Rajapack AB", 0, 21],
"R": 831
}, {
"C": ["Rajapack AB, Sweden", 1],
"R": 1855
}, {
"C": ["FSC-C183638", "DNV-COC-002535", "SODAMCO EMIRATES FACTORY FOR BUILDING MATERIALS - LLC", 0, 17],
"R": 828
}, {
"C": ["FSC-C183821", "SCS-COC-009486", "SEONGWONSUCHLPOJANG", "-", 19],
"R": 444
}, {
"C": ["FSC-C183878", "SCS-COC-009493", "Wettpex Hygiene Wipes s.r.o.", 13],
"R": 956
}, {
"C": ["FSC-C184160", "SA-COC-013620", "BİMS AMBALAJ SANAYİ VE TİCARET ANONİM ŞİRKETİ", 26],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C184290", "DNV-COC-002543", "Froben Druck GmbH & Co. KG", 22],
"R": 956
}, {
"C": ["FSC-C184368", "SGSHK-COC-331662", "Putian Hongsen Industry & Trade Co., Ltd.", "Fujian Province,", 6],
"R": 444
}, {
"C": ["FSC-C184399", "BV-COC-184399", "Jinhua Youli Daily Necessities Co. , Ltd.", 17],
"R": 1468
}, {
"C": ["FSC-C184484", "BV-COC-184484", "Shandong Shunhang Home Furnishings Co., Ltd", 41],
"R": 1468
}, {
"C": ["FSC-C184617", "SA-COC-013653", "Wuzhou Huizhengchangrong Wood Industry Co ., Ltd", "Guangxi Province"],
"R": 1468
}, {
"C": ["FSC-C184618", "SA-COC-013654", "Heilongjiang Hexu International Trade Co., Ltd.", "HEILONGJIANG PROVINCE"],
"R": 1468
}, {
"C": ["FSC-C184736", "SGSHK-COC-310865", "Bazhou Yujinxin Wood Industry Co.,Ltd", "Hebei Province, P.R."],
"R": 1468
}, {
"C": ["FSC-C184768", "SCS-COC-009561", "RIO LINDO GIFTS", "-", 49],
"R": 444
}, {
"C": ["FSC-C184848", "BV-COC-184848", "Sercomm Philippines Inc.", "Philippines", 35],
"R": 444
}, {
"C": ["FSC-C184858", "SA-COC-013675", "ALYA PACKAGING AMBALAJ SANAYİ VE TİCARET LİMİTED ŞİRKETİ", 26],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C185026", "GFA-COC-006910", "Zhejiang Xiaoyu Packaging Technology Co., Ltd.", 6],
"R": 956
}, {
"C": ["FSC-C185028", "CU-COC-892826", "Zaklad Przemyslowo-Handlowy Modrzew Adam Jacek", 8],
"R": 956
}, {
"C": ["FSC-C185066", "CU-COC-892881", "ALINA KAŹMIERCZAK P.P.H.U"],
"R": 1980
}, {
"C": ["FSC-C185087", "DNV-COC-002561", "CASTUERA INDUSTRIAS GRAFICAS, S.A", "NAVARRA", 9],
"R": 444
}, {
"C": ["FSC-C185142", "GFA-COC-006912", "TAIZHOU HUANGYAN LICHANG ARTS AND CRAFTS CO., LTD.", 6],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C185222", "SCS-COC-009593", "Alvi-Bel Sp.z.o.o.", "-", 8],
"R": 444
}, {
"C": ["FSC-C185412", "RINA-COC-002184", "Guangzhou Sawtru Wood Products Limited", 55, 6],
"R": 444
}, {
"C": ["FSC-C185467", "SGSHK-COC-310880", "QINGDAO LIAN WOOD INDUSTRIAL CO.,LTD", "SHANDONG PROVINCE, P.R."],
"R": 1468
}, {
"C": ["FSC-C185648", "BMC-COC-010024", "RusBirch Plywood - Unipessoal, Lda", 39],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C185670", "TT-COC-008023", "ARG ORMAN ÜRÜNLERİ SANAYİ VE TİCARET LİMİTED ŞİRKETİ", 26],
"R": 956
}, {
"C": ["ORKUN ORMAN ÜRÜNLERİ İÇ VE DIŞ TİCARET LİMİTED ŞİRKETİ", 1],
"R": 1855
}, {
"C": ["FSC-C185678", "SAI-COC-009822", "Guangzhou Hengtai Printing Technology Co., LTD", 0, "Guangdong", 6],
"R": 316
}, {
"C": ["FSC-C185710", "BMC-COC-010025", "GRAMOL GRAFICAS, SCP", 9],
"R": 444,
"Ø": 512
}, {
"C": ["FSC-C016072", "SGSCH-FM/COC-003877", 1673136000000, 1825545600000, "Novelteak Nicaragua S. A.", 50],
"R": 908
}]
}],
"IC": false,
"RT": [
["datetime'2023-01-08T00:00:00'", "'FSC-C016072'", "'SGSCH-FM/COC-003877'", "'Valid'", "'No'", "datetime'2027-11-07T00:00:00'", "'Novelteak Nicaragua S. A.'", "'Certificate holder'", "'Valid'", null, "'NICARAGUA'"]
],
"ValueDicts": {
"D0": ["FSC-C114530", "FSC-C131938", "FSC-C139483", "FSC-C021412", "FSC-C084285", "FSC-C114502", "FSC-C139058", "FSC-C114484", "FSC-C114582", "FSC-C114606", "FSC-C138487", "FSC-C139414", "FSC-C139575", "FSC-C006266", "FSC-C010588", "FSC-C019074", "FSC-C114214", "FSC-C114474", "FSC-C114713", "FSC-C136386", "FSC-C139361", "FSC-C139373", "FSC-C139380", "FSC-C016109", "FSC-C114429", "FSC-C114485", "FSC-C139264", "FSC-C173342", "FSC-C114100", "FSC-C114278", "FSC-C114406", "FSC-C136546", "FSC-C138729", "FSC-C139063", "FSC-C139363", "FSC-C139408", "FSC-C114477", "FSC-C114663", "FSC-C138929", "FSC-C139221", "FSC-C139270", "FSC-C139335", "FSC-C139439", "FSC-C139451", "FSC-C014046", "FSC-C020000", "FSC-C114422", "FSC-C115093", "FSC-C139293", "FSC-C139304", "FSC-C114285", "FSC-C114350", "FSC-C114358", "FSC-C114360", "FSC-C114361", "FSC-C007925", "FSC-C010685", "FSC-C139265", "FSC-C139334", "FSC-C139407", "FSC-C185272", "FSC-C002394", "FSC-C013510", "FSC-C103831", "FSC-C119686", "FSC-C128098", "FSC-C128705", "FSC-C133695", "FSC-C139242", "FSC-C139243", "FSC-C139246", "FSC-C139255", "FSC-C143263", "FSC-C145910", "FSC-C153513", "FSC-C161127", "FSC-C170110", "FSC-C173022", "FSC-C176029", "FSC-C182385", "FSC-C182793", "FSC-C182802", "FSC-C184022", "FSC-C184463", "FSC-C184534", "FSC-C184750", "FSC-C184831", "FSC-C184838", "FSC-C184945", "FSC-C185006", "FSC-C185160", "FSC-C185392", "FSC-C185449", "FSC-C185597", "FSC-C185607", "FSC-C185812", "FSC-C002560", "FSC-C007031", "FSC-C007631", "FSC-C008364"],
"D1": ["SQS-COC-500033", "SA-FM/COC-006160", "SGSHK-COC-370155", "SGSHK-COC-001964", "SGSCH-COC-004176", "SA-COC-003871", "SGSHK-COC-350206", "SA-COC-003870", "TUEV-COC-001190", "CU-COC-826952", "AEN-COC-000196", "TUEV-COC-001197", "SAI-COC-002873", "CU-COC-849759", "SGSHK-COC-004140", "SGSHK-COC-004139", "RR-COC-000180", "SGSHK-COC-009713", "ICILA-COC-002412", "BV-COC-136386", "SCS-COC-007690", "SA-COC-006152", "ICILA-COC-003178", "SA-FM/COC-007996", "BV-COC-188372", "NC-COC-016492", "BV-COC-139264", "CQ-COC-000618", "BV-COC-009547", "BV-COC-200582", "SGSCH-COC-060006", "SGSCH-FM/COC-011091", "BV-COC-138729", "BV-COC-139063", "SGSCH-COC-011199", "SAI-COC-002861", "SGSCH-COC-610010", "SGSCH-COC-020016", "SGSHK-COC-350205", "SGSHK-COC-350212", "BV-COC-139270", "SKH-COC-000693", "SGSHK-COC-340071", "SGSHK-COC-340072", "SQS-COC-100292", "SGSCH-COC-000091", "SGSHK-COC-010794", "SAI-COC-001634", "SGSHK-COC-370152", "AEN-COC-000694", "SQS-COC-100894", "SA-COC-003863", "SA-COC-003864", "SA-COC-003865", "INT-COC-001249", "SGSHK-COC-004118", "SQS-COC-100287", "ICILA-COC-003182", "SAI-COC-002877", "SAI-COC-002860", "TUVDC-COC-888188", "NC-COC-002039", "CU-COC-856807", "ICILA-COC-000446", "ICILA-COC-002660", "RINA-COC-000059", "ICILA-COC-002942", "SCS-COC-005820", "SA-COC-006136", "SA-COC-006137", "SA-COC-006138", "SA-COC-006141", "RINA-COC-001899", "RINA-COC-000447", "TUVDC-COC-101162", "SCS-COC-007643", "RINA-COC-001302", "ICILA-COC-004404", "GFA-COC-006934", "ICILA-COC-004499", "SGSCH-COC-800060", "CU-COC-889034", "SCS-COC-009499", "ESTS-COC-222335", "SA-COC-013643", "NC-COC-071617", "ESTS-COC-222387", "TSUD-COC-002188", "GFA-COC-006905", "SCS-COC-009571", "TSUD-COC-002195", "RINA-COC-002191", "RINA-COC-002190", "SGSHK-COC-310884", "SA-COC-013734", "TT-COC-008025", "NEO-COC-002560", "SGSHK-COC-004640", "SQS-COC-100264", "SGSCH-COC-004098"],
"D2": ["Valid"],
"D3": ["No", "Yes"],
"D4": ["Casalini e Viscardi S.r.l.", "PT Karya Lestari", "HASA PRODUCTION – EXPORT COMPANY LIMITED", "TAIHEI SHOKAI CO., LTD.", "Produlith Inc.", "Wood Cloez (PTY) LTD", "Chubu Printing Center", "DCS Chubu", "DCS Fukuoka", "DCS Kumamoto", "DCS Tokyo", "FUKUHAKU PRINTING CO., LTD", "Kyushu Printing Center", "Guilin Lanhome Trading Co.,Ltd", "Global Chair Components Ltd", "Abatec Spółka z o.o.", "ZESTAN, S.A.", "TESSITURA MARCO PASTORELLI SPA", "Dongguan Canning Printing Co., Ltd.", "P.P.H. DANKROS Sp. z o.o.", "Fuji Offset Co., Ltd.", "Shinjuku Sales Office", "The Fifth Factory", "The Second Factory", "The Third Factory", "Narita Binding Factory", "Narita Factory", "Taihei Co., Ltd. Printing Division", "Uruido Factory", "Lishui Tianzhen Import & Export Co., Ltd. Of Zhejiang Province", "Kimberly-Clark Products (M) Sdn. Bhd.", "TOSCANA ONDULATI SPA", "FUJIAN SANMING CITY DONGLAI WOOD CO.,LTD.", "Tallinna Raamatutrükikoja OÜ", "Zhejiang Xinbo Baby&Juvenile Products Co.,Ltd.", "ODDICINI SRL", "Prentiss & Carlisle Management Co., Inc.", "DREWMARK MAREK WOLIŃSKI W SPADKU", "Holz Schiller s. r. o. (Cheb)", "WEI JANG PAPER CO.", "OBERLECHNER HOLZ S.R.L.", "QINGDAO SINOPACKAGE CO.,.LTD.", "COECO d.o.o.", "TONEWOODS, S.L.", "Anxiang County Jianren Tree Planting Cooperatives", "Changde City Dingcheng District Dongbeiwan Tree Planting Cooperatives", "Hanshou County Friendship Wood Co., LTD", "Hunan Dongting Baiyang Forestry Co., Ltd.", "Hunan Maoyuan Forestry Co. Ltd.", "Hunan Senhai Forestry Co., Ltd.", "State-owned Sanmenjiang Forest Farm of Guangxi Zhuang Autonomous Region", "STAVIAN PULP & PAPER JOIN STOCK COMPANY", "TAICHANG WRAPPER COMPANY LIMITED", "“DRVO SISTEM 07” d.o.o.", "Zhuhai City Heng Mei Printing Products Co., Ltd.", "MEDAD PRINTING AND PACKAGING", "Bluespot Furniture Limited", "CHUBUSIGYOU INC", "Marubayashi Seishi Inc.", "HANDY CARTON CO., LTD", "Arcon B.V.", "Ban Bouw Holding B.V.", "BanBouw B.V.", "Bouwcombinatie Moeskops- BanBouw vof", "SAEHWA CORRUGATED PACKAGING CO., LTD", "HANSUNG COLOR CO., LTD.", "CIL Centre d'impression Lausanne SA", "DZB Druckzentrum Bern AG", "DZZ Druckzentrum Zürich AG", "Tamedia Publikationen Deutschschweiz AG Tamedia Verlangsservices", "Billerud Sweden AB, Karlsborg Bruk", "QUI NHON WOODCHIP CO., LTD (QNWC)", "Hangzhou Huawang New Material Technology Co., Ltd", "CHUNG PHAT HUNG YEN CO., LTD.", "SUNYOUNG (CHONGQING) PACKING CO., LTD", "Multicork Solutions Tanja Kattinger e.Kfr.", "Usutu Forest Products Company Limited: Armagh Mill", "Usutu Forest Products Company Limited: Bhunya Mill", "Usutu Forest Products Company Limited: Usutu Forest Products Company – Creosote Plant", "Pedrali Spa", "Tzaneng Treated Timbers (Pty) Ltd", "Magazzini Carta Rumor Arci Srl", "Hashimoto Kakubundo Co., Ltd.", "RITZ CROSSMEDIA AG", "GIUNTATURA TRANCIATI DI CARNIEL GIANNINO & C. SNC", "Fibrek S.E.N.C., Saint Félicien Pulp Mill", "Produits Forestiers Mauricie S.E.C P.F., Mauricie sawmill", "Resolute Forest Products Inc., Central Office Montreal", "Resolute Forest Products US Inc.", "Resolute FP Canada Inc. Girardville-Normandin Sawmill", "Resolute FP Canada Inc. Seneterre - Lac Clair Sawmill", "Resolute FP Canada Inc., Alma Paper Mill", "Resolute FP Canada Inc., Amos Paper Mill", "Resolute FP Canada Inc., Bureau des ventes (Sales Office Canada)", "Resolute FP Canada Inc., Château-Richer sawmill", "Resolute FP Canada Inc., Thunder Bay Pulp & Paper Mill", "Resolute FP Canada Inc., Baie-Comeau Paper Mill", "Resolute FP Canada Inc., Clermont Paper Mill", "Resolute FP Canada Inc., Comtois sawmill", "Resolute FP Canada Inc., Dolbeau Paper Mill"],
"D5": ["Certificate holder", "Site"],
"D6": ["Valid", "Invalid"],
"D7": ["LC", "East Kalimantan", "Osaka", "Québec", "Limpopo", "Aichi", "Fukuoka", "Kumamoto", "Tokyo", "Saga", "Guangxi", "Suffolk", "Barcelona", "VA", "podkarpackie", "Chiba", "LU", "Zhejiang Province", "VB", "Maine", "Bolzano", "Valencia", "Hunan Province", "Guangxi Zhuang Autonomous Region", "Guangdong,", "West Yorkshire", "Kochi", "VD", "BE", "ZH", "Karlsborgsverken", "CHONGQING", "(BG)", "(VI)", "Ishikawa", "TV", "Alabama", "Mississippi", "Tennessee", "Ontario", "TN", "Shandong Province", "California", "TE", "MB", "Arkansas", "Hubei Province", "BALIKESİR", "Judetul Mures", "Dhaka", "BG", "Jiangsu", "FC", "SF", "Chernihivska oblast", "Guangdong Province", "Santa Catarina", "São Paulo", "Anhui Province, P.R.", "Bahia", "AG", "Connecticut", "warmińsko-mazurskie", "Olongapo City", "italia", "Penang", "Binh Duong Province", "Bình Dương Province", "Hong Kong", "Dong Nai Province", "Khanh Hoa Province", "Lower Silesian", "Zala", "Pu Dong New Area", "lfov county", "Pará", "Ilfov county", "MN", "Oregon", "Buenos Aires", "FI", "Zhytomyr region", "mazowieckie", "Pomorskie", "wielkopolskie", "Khmelnitskiy Region", "Berlin", "PESARO E URBINO", "Karnataka", "Zhejiang Province,", "Rajasthan", "MI", "SC", "Fujian", "Essex", "Texas, TX", "quebec", "Georgia, GA", "CO", "TX"],
"D8": ["ITALY", "INDONESIA", "VIETNAM", "JAPAN", "CANADA", "SOUTH AFRICA", "CHINA", "UNITED KINGDOM", "POLAND", "SPAIN", "MALAYSIA", "ESTONIA", "UNITED STATES", "CZECH REPUBLIC", "TAIWAN", "SLOVENIA", "SERBIA", "UNITED ARAB EMIRATES", "NETHERLANDS", "KOREA, REPUBLIC OF", "SWITZERLAND", "SWEDEN", "GERMANY", "ESWATINI", "ROMANIA", "CHILE", "TURKEY", "INDIA", "BANGLADESH", "URUGUAY", "ARGENTINA", "UKRAINE", "BRAZIL", "BELGIUM", "ISRAEL", "PHILIPPINES", "HONG KONG", "HUNGARY", "CROATIA", "PORTUGAL", "BULGARIA", "LATVIA", "FRANCE", "AUSTRALIA", "SAINT VINCENT AND THE GRENADINES", "EGYPT", "SAINT KITTS AND NEVIS", "DENMARK", "NORWAY", "LITHUANIA", "NICARAGUA"]
}
}]
}
}
}
}]
}On the drill-down page, the Group members are queried like this:
POST https://wabi-west-europe-api.analysis.windows.net/public/reports/querydata?synchronous=true
The most important part is the condition.value property of the request JSON where the website specifies which certificate holder we get the data for. In this case it is 'FSC-C019676'.
{
"version": "1.0.0",
"queries": [{
"Query": {
"Commands": [{
"SemanticQueryDataShapeCommand": {
"Query": {
"Version": 2,
"From": [{
"Name": "o",
"Entity": "Organization",
"Type": 0
}, {
"Name": "c",
"Entity": "Country Data",
"Type": 0
}, {
"Name": "c1",
"Entity": "Certificate",
"Type": 0
}],
"Select": [{
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "Organization Name"
},
"Name": "Organization.Organization Name"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "Street__c"
},
"Name": "Organization.Street__c"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "Town_City__c"
},
"Name": "Organization.Town_City__c"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "Type"
},
"Name": "Organization.Type"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "c"
}
},
"Property": "Country"
},
"Name": "Country Data.Country"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "FSC_Site_subcode__c"
},
"Name": "Organization.FSC_Site_subcode__c"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "Date_To__c"
},
"Name": "Organization.Date_To__c"
}, {
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "State_County__c"
},
"Name": "Organization.State_County__c"
}],
"Where": [{
"Condition": {
"Not": {
"Expression": {
"In": {
"Expressions": [{
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "Type (groups)"
}
}],
"Values": [
[{
"Literal": {
"Value": "'Certificate holder'"
}
}]
]
}
}
}
}
}, {
"Condition": {
"In": {
"Expressions": [{
"Column": {
"Expression": {
"SourceRef": {
"Source": "c1"
}
},
"Property": "License"
}
}],
"Values": [
[{
"Literal": {
"Value": "'FSC-C019676'"
}
}]
]
}
}
}],
"OrderBy": [{
"Direction": 1,
"Expression": {
"Column": {
"Expression": {
"SourceRef": {
"Source": "o"
}
},
"Property": "FSC_Site_subcode__c"
}
}
}]
},
"Binding": {
"Primary": {
"Groupings": [{
"Projections": [0, 1, 2, 3, 4, 5, 6, 7]
}]
},
"DataReduction": {
"DataVolume": 3,
"Primary": {
"Window": {
"Count": 500
}
}
},
"Version": 1
},
"ExecutionMetricsKind": 1
}
}]
},
"QueryId": "",
"ApplicationContext": {
"DatasetId": "d94c3e96-8435-4af1-b2ba-21ef6defaa95",
"Sources": [{
"ReportId": "8be6b660-e5ba-422d-951f-797c9e2a4af7",
"VisualId": "0fa64224e34425e3ea25"
}]
}
}],
"cancelQueries": [],
"modelId": 4930701
}The same logic is being done for most of the drilldown pages. It does 8 more requests like the previous one to get all of the data. We need to simulate all of it.