Building a filter
Javascript Example
var filters = {
'rowFilters': [
{"operator":"<", "inclusive":false, "caseSensitive":false, "value":"5", "attribute":"consensus-value", "fieldId":50},
...
],
'voteFilters': [
{"operator":"neq", "name":2, "value":"admin", "attribute":"user_id"},
...
]
};
params = { 'filters': JSON.stringify(filters)}
Ruby Example
API_PATH="http://api.factual.com/v1/" + YOUR_API_KEY
def make_call(controller,action,key=nil, payload={})
url = API_PATH + "/" + controller
url += "/" + key if key
url += "/" + action
res = Net::HTTP.post_form(URI.parse(url),payload)
JSON.parse(res.body)
end
def simple_row_filter(operator,field,value=nil)
filter = {'fieldId'=>field,'operator'=>operator, 'attribute'=>"consensus-value", 'value'=>value}
end
row_filters=[]
row_filters << simple_row_filter("eq",12345,"Los Angeles")
row_filters << simple_row_filter("contains",12346,"Calif")
filters={'rowFilters'=>row_filters}
make_call('tables','read','tBlKeY',{'filters'=>filters.to_json})