Examples: query, "exact match", wildcard*, wild?ard, wild*rd
Fuzzy search: cake~ (finds cakes, bake)
Term boost: "red velvet"^4, chocolate^2
Field grouping: tags:(+work -"fun-stuff")
Escaping: Escape characters +-&|!(){}[]^"~*?:\ with \, e.g. \+
Range search: properties.timestamp:[1587729413488 TO *] (inclusive), properties.title:{A TO Z}(excluding A and Z)
Combinations: chocolate AND vanilla, chocolate OR vanilla, (chocolate OR vanilla) NOT "vanilla pudding"
Field search: properties.title:"The Title" AND text
Answered
Hi All, I Have A Big Amount Of Experiment In A Single Project, There Is A Way To Download The Experiments As A Custom Table? To Let'S Say To A .Csv File? Thanks! Experiment Table Example:

Hi all,
I have a big amount of experiment in a single project,
there is a way to download the experiments as a custom table? to let's say to a .csv file?
Thanks!

experiment table example:
image

  
  
Posted 2 years ago
Votes Newest

Answers 6


Or you're thinking only of the current view as it is?

  
  
Posted 2 years ago

I think the call tasks.get_all should have you covered to extract all information you would need.
None
The request body should look something like this:

{
  "id": [],
  "scroll_id": "b77a32d585604b098f685b00f30ba2c2",
  "refresh_scroll": true,
  "size": 15,
  "order_by": [
    "-last_update"
  ],
  "type": [
    "__$not",
    "annotation_manual",
    "__$not",
    "annotation",
    "__$not",
    "dataset_import"
  ],
  "user": [],
  "system_tags": [
    "__$and",
    "__$not",
    "archived"
  ],
  "include_subprojects": true,
  "search_hidden": true,
  "only_fields": [
    "name",
    "status",
    "system_tags",
    "project",
    "company",
    "last_change",
    "started",
    "last_iteration",
    "tags",
    "user.name",
    "runtime.progress",
    "type",
    "project.name",
    "last_update",
    "parent.name",
    "parent.project.id",
    "parent.project.name"
  ]
}

Tip: Anything that you want to extract from the UI, you can use the API. To find the relevant call you can always open developer tools (F12) and see what returns

  
  
Posted 2 years ago

Cool! Thanks I will check it out!

  
  
Posted 2 years ago

Hi CostlyOstrich36 ,
I need it the most "dry" way (only basic columns of strings, ints and floats), no fancy tags are required.

  
  
Posted 2 years ago

OK, I ended up extracting it from the browser source code with good old copy-paste.
However, I'm definitely need to use the API next time!
Thanks!!!

  
  
Posted 2 years ago

Hi PleasantOtter67 , nothing out of the box. You can however quite easily extract all that information and inject it into a csv programmatically.

I think the bigger question is how would you break it down? Each experiment has several nested properties.

  
  
Posted 2 years ago