Hi Henning, Well, it works fine if the document is a "flat JSON" without arrays and other sub-objects in it. I tried with and without escaping quotation marks, but no luck.
ERROR: db_mongodb [mongodb_dbase.c:452]: db_mongodb_get_columns(): field ["Location":"Prefix"] not found in result iterator ERROR: db_mongodb [mongodb_dbase.c:452]: db_mongodb_get_columns(): field [Location:Prefix] not found in result iterator Regards, --Sergiu On Tue, Mar 2, 2021 at 12:11 PM Henning Westerholt <[email protected]> wrote: > Hi Sergiu, > > > > I did not try it by myself so far, maybe others can comment on it. > Normally you should be able to use the htable module on all usual database > modules (that offer the needed capabilities). > > What are the error messages that you get, maybe there are some hints in it? > > > > Cheers, > > > > Henning > > > > -- > > Henning Westerholt – https://skalatan.de/blog/ > > Kamailio services – https://gilawa.com > > > > *From:* sr-users <[email protected]> *On Behalf Of *Sergiu > Pojoga > *Sent:* Tuesday, March 2, 2021 4:39 PM > *To:* Kamailio (SER) - Users Mailing List <[email protected]> > *Subject:* [SR-Users] Load htable from MongoDB > > > > Hi there, > > > > Question: is it possible to load a htable, defined by columns, from a > MongoDB collection, when a certain "column" is an object with multiple > elements? > > > > For example: > > modparam("htable", "htable", > "users=>size=10;dbtable=users;cols='FirstName,LastName,Location:Prefix';") > > > > Fails when trying to load the value of Location.Prefix > > > > { > "FirstName": "John", > "LastName": "Doe", > "Language" : "en", > "Location" : { > "Country" : "USA", > "City" : "New York", > "Prefix" : "+1" > } > } > > > > Thanks in advance. >
_______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
