...
1- Consulte/exporte os dados retornados da consulta:
Bloco de código |
---|
- curl -X 'POST' \
'https://totvsclockin.carol.ai/api/v3/queries/named/clockinrecordsListByPeriod?indexType=MASTER&offset=0&pageSize=10&sortBy=mdmGoldenFieldAndValues.mdmeventdate&sortOrder=DESC&scrollable=false' \
-H 'accept: application/json' \
-H 'Content-Type: application/json' \
-H 'Authorization: Bearer {seu token}' \
-d '{
"nsrCode": "748",
"deviceCode": "BE1C11B2-5DEC-4878-88E6-175981481398",
"initialDate": "2024-08-01T00:00:00.000-03:00",
"finalDate": "2024-09-01T00:00:00.000-03:00",
}' |
Bloco de código |
---|
{ "count": 6, "totalHits": 6, "took": 4, "hits": [ { "mdmDeleted": false, "mdmSourceOperation": "SQL_PROCESS", "mdmCounterForEntity": 1724761025743000, "mdmGoldenFieldAndValues": { "clockinmode": "1", "smssent": "2024-08-27T03:32:34.990Z", "supervisorcode": "[email protected]", "isautotimezone": "2", "selfclockin": true, "lastgpsdatetime": "2024-08-21T12:15:29.000-03:00", "nsrprocesseddatetime": "2024-08-21T15:22:25.440Z", "devicetimezonechangeindicator": "1", "score": "6", "supervisorname": "[email protected]", "appname": "Clock In", "eventdatestr": "2024-08-21T12:15:00.000-03:00", "updatedatetimeautomatically": false, "lastmomentgpsdatetimeobtained": "2024-08-21T12:15:29.322-03:00", "employeegeofencecoordinatesoptional": "no coordinates", "receiptimage": "https://teste.carol.ai/teste/go/728ywobccj", "mdmname": "Colaborador Exemplo", "devicedescription": "[email protected]", "datetimechanged": false, "image": "https://teste.carol.ai/teste/go/raxoohcav9", "nsrcode": "753", "coordinatesaccuracy": 6, "diffgpsdevicetime": "0", "collectiveagreement": "99999999999999999", "gpslevel": "0", "locationcode": "4", "licensestatus": "OK", "mdmStagingAuditId": "f5ac249636ec0e34", "fraudscore": 0.0026708, "statusanalysisdate": "2024-08-21T21:09:10.514Z", "receiptsentmode": "Nothing", "readphonestateenabled": false, "gmt": "-03:00", "devicecode": "BE1C11B2-5DEC-4878-88E6-175981481398", "georeferencestate": "filled", "mdmTaskId": "b0a898893037441fbc3cd42d8353f9c2", "imagehash": "-0.131479, 0.0294967, 0.0692975, -0.0225383, -0.0269747, -0.0752967, -0.0515807, -0.120229, 0.180412, -0.125723, 0.218578, -0.00439189, -0.253444, -0.118369, 0.002121, 0.117364, -0.0208364, -0.0767907, -0.0751632, -0.0915777, 0.0742972, 0.0451878, 0.0465591, 0.0654342, -0.0633498, -0.339759, -0.0660675, -0.115597, 0.02133, -0.0735729, -0.0318694, 0.0118895, -0.103082, -0.113205, 0.0400811, 0.112948, -0.0746193, -0.0700653, 0.198791, -0.00607182, -0.119064, -0.0749938, 0.0507131, 0.272417, 0.158889, 0.0524132, 0.0531848, -0.0839153, 0.15459, -0.277452, 0.152825, 0.0625031, 0.183316, 0.0599122, 0.20305, -0.146557, 0.0588035, 0.193805, -0.266038, 0.158633, 0.077579, -0.0514593, -0.104153, -0.00862041, 0.249977, 0.166787, -0.132382, -0.0749751, 0.200977, -0.136508, -0.062053, 0.0602444, -0.0952025, -0.207354, -0.218461, 0.0460927, 0.363987, 0.223373, -0.219258, 0.00230355, -0.0482604, 0.00519569, 0.0950405, 0.0393352, -0.0476836, -0.0534268, -0.0686621, -0.0298764, 0.111147, 0.0586453, -0.0532365, 0.272703, 0.0270942, -0.0053324, 0.0387958, 0.0122857, -0.130904, -0.0270901, -0.152075, -0.124179, 0.116132, -0.0682318, 0.0681907, 0.0567057, -0.219154, 0.198706, -0.0320844, 0.0369035, 0.0939216, -0.0129052, -0.104225, 0.0190724, 0.131557, -0.237321, 0.196939, 0.105615, 0.103404, 0.166686, 0.040076, 0.0371103, 0.0908808, -0.0865782, -0.173796, -0.0864644, 0.0326179, -0.0310395, 0.0630728, 0.0668265", "isuserinsidegeofenceenum": "1", "statusanalysis": "OK", "externalservicestatuscode": 0, "coordinates": { "lon": -48.38827807460761, "lat": -22.370139551369817 }, "datetimeprovider": "ntp", "fakegpslocation": false, "devicesynchistorycode": "1724253342422", "mdmtaxid": "755", "locationdescription": "Joinville", "clockinsessionstatus": "logged-in", "mdmeventdate": "2024-08-21T15:15:00.000Z", "imei": "", "gmtfromclockinscoordinates": "-03:00", "mdmpersonid": "12345678910" }, "mdmConstraintPending": false, "mdmEntityType": "clockinrecordsGolden", "mdmStagingRecordIds": [ "99eb05dd32446c8dd11d0171d995160e" ], "mdmSourceType": "SQL", "mdmMergePending": false, "mdmLastUpdated": "2024-08-27T12:17:05Z", "mdmTenantId": "1ff0fbe4de2143bbab686413a3c359ca", "mdmMasterCount": 1 |
...
,
"mdmStagingCounter": "1724729567118246",
"mdmCreated": "2024-08-27T12:17:05Z",
"mdmSourceOperationTaskId": "b0a898893037441fbc3cd42d8353f9c2",
"mdmSourceEntityNames": [
"bf2ace1f69f34529850e3b983feb8271_clockinrecords"
],
"mdmEntityTemplateId": "7dd4da9d15294d46a6da8e27f179690f",
"mdmId": "ca04aa98aed7b20e5eb450a397c7ea99"
},
{...},
{...},
{...},
{...},
{...}
],
"aggs": {}
} |