> q1@values %>% head(2) recordId healthCode createdOn appVersion phoneInfo 1 d5440ad1-9199-4d99-9071-0b358c1025d0 4676049f-9697-4fd9-ba1e-f5dbfa395fed 2015-04-22 02:45:11 version 1.0.5, build 12 iPhone 6 Plus 2 965e04ad-be1b-4673-97e5-3bd826db56b7 a80b37d7-f9f4-482f-8918-f1235da37f2b 2015-04-22 05:21:06 version 1.0.5, build 12 iPhone 6 accel_walking_outbound.json.items deviceMotion_walking_outbound.json.items pedometer_walking_outbound.json.items 1 3212460 3212479 3212495 2 3216698 3216715 3216734 accel_walking_return.json.items deviceMotion_walking_return.json.items pedometer_walking_return.json.items accel_walking_rest.json.items 1 3212517 3212534 3212550 3212566 2 3216751 3216768 3216784 3216802 deviceMotion_walking_rest.json.items 1 3212584 2 3216819 > type="deviceMotion_walking_return" > files <- synDownloadTableColumns(q1, paste0(type,".json.items")) > sapply(files,file.size) %>% summary() Min. 1st Qu. Median Mean 3rd Qu. Max. 4 4 4 4 4 4 > scan(files[[1]],'char') Read 1 item [1] "null" > save(q1,file='bad_file.query') > >sapply(files,file.remove) >files <- synDownloadTableColumns(q1, paste0(type,".json.items")) #it downloads the same empty files See R 'q1 ' object in https://drive.google.com/file/d/0B2NLCeM3RRN2dXprYjJaMFNtRkk/view?usp=sharing Best, Vlad