To GoodData homepage

Replies posted by alejandro.rivera

5 Replies

A
alejandro.riveraInspiring
asked in SDKs and APIs

Filter out future empty values

Hi Jan,OK sorry, I don’t think I did a good job explaining my question before.So this is the actual metric:SELECT COUNT(Conversation) WHERE Customer Gender [Customer Gender] IN ((empty value))Now this is reality looks like this:SELECT COUNT([/gdc/md/qplm123456n2d919mlflrxdgi6gs1qv/obj/1582]) WHERE [/gdc/md/qplmcrc9y1234569mlflrxdgi6gs1qv/obj/1747]  IN ([/gdc/md/qplmcrc9123456mlflrxdgi6gs1qv/obj/1746/elements?id=1478]) So the problem with this (I think) is that the query asssumes that the empty value exists in order to find the uri with the element id.How can I replicate a metric like this assuming that an empty value doesn’t yet exist, how can I apply the IFNULL statement here? 

3
Jan Kos
GoodData Employee
1 year ago
A
alejandro.riveraInspiring
asked in SDKs and APIs

How to create report domain?

amazing, thank you Jan :)

6
A
1 year ago
A
alejandro.riveraInspiring
asked in SDKs and APIs

How to create report domain?

omg that worked! awesome thanks!Can I ask you something else?How can I get the uri from a domain using the name? In later runs I want to check if the domain already exists before creating it again.  For metrics folders I would find it like this:all_folders = GoodData::Folder.all({client: client, project: project_target })folder = all_folders.find{ |f| f.title == folder_title } 

6
A
1 year ago
A
alejandro.riveraInspiring
asked in SDKs and APIs

How to create report domain?

Hi Jan,Thanks again for responding!I’m sure that this would work but it seems that I don’t have the permissions? which is weird because I’m using the same client object that I use to create reports, metrics, etc.I’ve got this response:403 Forbidden: Invalid operation request_id: :tBxu9Nu_-GDFW9WSnt6OTQ:zn-ju3k-661zl2LHQ2X5Qw:kIjNUZZYGXFzQXH9 (RestClient::Forbidden) Here is my code, is there anything wrong with it?  The first 2 lines I always use them to create the client and project. Does this means that I’m missing some permissions? client = GoodData.connect(options[:user_name], options[:password], server: options[:server] )project_target = client.projects( data['target_workspace'] )client.post("#{project_target.uri}/obj?createAndGet=true", { "domain"=>{ "meta"=>{ "title"=>"Folder_for_testing", "summary"=>"", "tags"=>"", "deprecated"=>0 }, "content"=>{ "entries"=>[] } }}) 

6
A
1 year ago
A
alejandro.riveraInspiring
asked in SDKs and APIs

Creating Reports via Ruby SDK

Hey Jan,Thanks for responding!Although my goal with this is to be able to create and saved the reports already filtered.I did find a workround though,  I actually had to modify this methodSpecifically this line'filters' => ReportDefinition.create_filters_part(filters, :project => project)I’ve changed it to:'filters' => filtersAnd I can just past the filters as:[{'expression'=> "Expression here"} , {'expression'=> "Expression here"} ]This doesn’t have limits and I can create any filter that I want, I don’t know why this is not possible with the Ruby SDK allowing only IN or NOT IN filtering. Thanks anyway!Alejandro

3
Jan Rehanek
GoodData Employee
1 year ago
Welcome to the GoodData Community!Cookie settings