Try The New Semantic Workshop!
The following examples illustrate how the simple display option works.
We’ll go over a few basic examples. We’ll only display portions of the responses here, but you will be able to view the full responses by following the links.
Meeting Searches
CSV Examples
- Get All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday.
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/csv/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19
- Response:
-
"id_bigint","worldid_mixed","shared_group_id_bigint","service_body_bigint","weekday_tinyint","start_time","duration_time","formats","lang_enum","longitude","latitude","email_contact","meeting_name","location_text","location_info","location_street","location_city_subsection","location_neighborhood","location_municipality","location_sub_province","location_province","location_postal_code_1","location_nation","comments","train_lines","bus_lines","contact_phone_2","contact_email_2","contact_name_2","contact_phone_1","contact_email_1","contact_name_1","format_B","format_BL","format_BT","format_C","format_CH","format_CL","format_CS","format_D","format_ES","format_GL","format_IL","format_IP","format_IW","format_JT","format_M","format_NC","format_O","format_Pi","format_RF","format_Rr","format_SC","format_SD","format_SG","format_SL","format_Sm","format_So","format_St","format_Ti","format_To","format_Tr","format_TW","format_W","format_WC","format_YP","format_OE","format_BK","format_NS","format_Ag","format_FD","format_AB" "24","00014731","","1005","1","16:15:00","01:30:00","O,RF","en","-73.905834","40.838762","","Meditation on Sundays","Our Lady of Victory Church","@171st St","1512 Webster Ave","Bronx","Claremont","New York","Bronx","NY","10457","USA","","","","","","","","","","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","1","0","1","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0" "346","00113665","","1010","1","16:30:00","01:30:00","C,JT,WC,BK","en","-73.976946","40.724846","","Just for Today","Housing Works, Ground Floor","Btwn Aves C&D","743 E 9th St","Manhattan","East Village","New York","New York","NY","10009","USA","","","","","","","","","","0","0","0","1","0","0","0","0","0","0","0","0","0","1","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","0","1","0","0","1","0","0","0","0" "803","00010448","","1001","1","17:00:00","02:00:00","O,D,St","en","-73.4077826142311","40.7096557895169","","Surrender On Sunday","Community Center (On East Street)","","East St. at Cedar St.","","","Amityville","Suffolk","NY","11701","USA","","","","","","","","","","0","0","0","0","0","0","0","1","0","0","0","0","0","0","0","0","1","0","0","0","0","0","0","0","0","0","1","0","0","0","0","0","0","0","0","0","0","0","0","0" "114","00000000","","1015","1","17:00:00","01:30:00","O,ES,St","es","-73.881634","40.880458","","Un Nuevo Empezar","North Central Bronx Hosp, Rm 14B07","Btwn E 210th St & Dekalb Ave","3424 Kossuth Ave","Bronx","Williamsbridge","New York","Bronx","NY","10467","USA","","Tren 4 hasta Mosholu Pkwy","Bus Bx 10 hasta Mosholu Pkwy","","","","","","","0","0","0","0","0","0","0","0","1","0","0","0","0","0","0","0","1","0","0","0","0","0","0","0","0","0","1","0","0","0","0","0","0","0","0","0","0","0","0","0" · · ·
Note that all of the fields are returned, and that empty fields are given (“‘”). This is required for valid CSV data. Also, each column is bounded by double-quotes (“). If the data contains a double-quote, that quote is escaped (\”). The first row is always a header, and contains the data item keys.
- Get All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday, and only return the town and meeting name.
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/csv/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19 &data_field_key=location_municipality,meeting_name
- Response:
-
"meeting_name","location_municipality" "Meditation on Sundays","New York" "Just for Today","New York" "Surrender On Sunday","Amityville" "Un Nuevo Empezar","New York" · · ·
Note that no meeting ID is returned. If you need that, you should also specify the
column:
- Get All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday, and only return the meeting ID, town and meeting name.
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/csv/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19 &data_field_key=location_municipality,meeting_name,id_bigint
- Response:
-
id_bigint","meeting_name","location_municipality" "24","Meditation on Sundays","New York" "346","Just for Today","New York" "803","Surrender On Sunday","Amityville" "114","Un Nuevo Empezar","New York" · · ·
Note also that the order in which the columns are returned is up to the server. The order in which they are specified in the URI is irrelevant.
XML Examples
- Get All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday.
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/xml/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19
- Response:
-
<?xml version="1.0" encoding="UTF-8"?> <meetings xmlns="https://old.bmlt.app" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://old.bmlt.app https://old.bmlt.app/stable/main_server/client_interface/xsd/GetSearchResults.php"> <row id="0"> <id_bigint>24</id_bigint> <worldid_mixed>00014731</worldid_mixed> <service_body_bigint>1005</service_body_bigint> <weekday_tinyint>1</weekday_tinyint> <start_time>16:15:00</start_time> <duration_time>01:30:00</duration_time> <formats>O,RF</formats> <lang_enum>en</lang_enum> <longitude>-73.905834</longitude> <latitude>40.838762</latitude> <meeting_name>Meditation on Sundays</meeting_name> <location_text>Our Lady of Victory Church</location_text> <location_info>@171st St</location_info> <location_street>1512 Webster Ave</location_street> <location_city_subsection>Bronx</location_city_subsection> <location_neighborhood>Claremont</location_neighborhood> <location_municipality>New York</location_municipality> <location_sub_province>Bronx</location_sub_province> <location_province>NY</location_province> <location_postal_code_1>10457</location_postal_code_1> <location_nation>USA</location_nation> </row> <row id="1"> <id_bigint>346</id_bigint> <worldid_mixed>00113665</worldid_mixed> <service_body_bigint>1010</service_body_bigint> <weekday_tinyint>1</weekday_tinyint> <start_time>16:30:00</start_time> <duration_time>01:30:00</duration_time> <formats>C,JT,WC,BK</formats> <lang_enum>en</lang_enum> <longitude>-73.976946</longitude> <latitude>40.724846</latitude> <meeting_name>Just for Today</meeting_name> <location_text>Housing Works, Ground Floor</location_text> <location_info>Btwn Aves C&D</location_info> <location_street>743 E 9th St</location_street> <location_city_subsection>Manhattan</location_city_subsection> <location_neighborhood>East Village</location_neighborhood> <location_municipality>New York</location_municipality> <location_sub_province>New York</location_sub_province> <location_province>NY</location_province> <location_postal_code_1>10009</location_postal_code_1> <location_nation>USA</location_nation> </row> <row id="2"> <id_bigint>803</id_bigint> <worldid_mixed>00010448</worldid_mixed> <service_body_bigint>1001</service_body_bigint> <weekday_tinyint>1</weekday_tinyint> <start_time>17:00:00</start_time> <duration_time>02:00:00</duration_time> <formats>O,D,St</formats> <lang_enum>en</lang_enum> <longitude>-73.4077826142311</longitude> <latitude>40.7096557895169</latitude> <meeting_name>Surrender On Sunday</meeting_name> <location_text>Community Center (On East Street)</location_text> <location_street>East St. at Cedar St.</location_street> <location_municipality>Amityville</location_municipality> <location_sub_province>Suffolk</location_sub_province> <location_province>NY</location_province> <location_postal_code_1>11701</location_postal_code_1> <location_nation>USA</location_nation> <comments>Last Sunday of every month is a Step meeting.</comments> </row> <row id="3"> <id_bigint>114</id_bigint> <worldid_mixed>00000000</worldid_mixed> <service_body_bigint>1015</service_body_bigint> <weekday_tinyint>1</weekday_tinyint> <start_time>17:00:00</start_time> <duration_time>01:30:00</duration_time> <formats>O,ES,St</formats> <lang_enum>es</lang_enum> <longitude>-73.881634</longitude> <latitude>40.880458</latitude> <meeting_name>Un Nuevo Empezar</meeting_name> <location_text>North Central Bronx Hosp, Rm 14B07</location_text> <location_info>Btwn E 210th St & Dekalb Ave</location_info> <location_street>3424 Kossuth Ave</location_street> <location_city_subsection>Bronx</location_city_subsection> <location_neighborhood>Williamsbridge</location_neighborhood> <location_municipality>New York</location_municipality> <location_sub_province>Bronx</location_sub_province> <location_province>NY</location_province> <location_postal_code_1>10467</location_postal_code_1> <location_nation>USA</location_nation> <train_lines>Tren 4 hasta Mosholu Pkwy</train_lines> <bus_lines>Bus Bx 10 hasta Mosholu Pkwy</bus_lines> </row> · · ·
Note that the actual response data is returned as optimized XML, which means that everything is crammed into one line. This has been formatted for your reading pleasure. Also note that not all rows have all elements. If data is not supplied for an element, the element is not provided at all, as opposed to an empty element.
- Get All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday, and only return the town and meeting name.
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/xml/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19 &data_field_key=location_municipality,meeting_name
- Response:
-
<?xml version="1.0" encoding="UTF-8"?> <meetings xmlns="https://old.bmlt.app" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://old.bmlt.app https://old.bmlt.app/stable/main_server/client_interface/xsd/GetSearchResults.php"> <row id="0"> <meeting_name>Meditation on Sundays</meeting_name> <location_municipality>New York</location_municipality> </row> <row id="1"> <meeting_name>Just for Today</meeting_name> <location_municipality>New York</location_municipality> </row> <row id="2"> <meeting_name>Surrender On Sunday</meeting_name> <location_municipality>Amityville</location_municipality> </row> <row id="3"> <meeting_name>Un Nuevo Empezar</meeting_name> <location_municipality>New York</location_municipality> </row> · · ·
- Get All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday, and only return the meeting ID, town and meeting name.
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/xml/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19 &data_field_key=location_municipality,meeting_name,id_bigint
- Response:
-
<?xml version="1.0" encoding="UTF-8"?> <meetings xmlns="https://old.bmlt.app" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://old.bmlt.app https://old.bmlt.app/stable/main_server/client_interface/xsd/GetSearchResults.php"> <row id="0"> <id_bigint>24</id_bigint> <meeting_name>Meditation on Sundays</meeting_name> <location_municipality>New York</location_municipality> </row> <row id="1"> <id_bigint>346</id_bigint> <meeting_name>Just for Today</meeting_name> <location_municipality>New York</location_municipality> </row> <row id="2"> <id_bigint>803</id_bigint> <meeting_name>Surrender On Sunday</meeting_name> <location_municipality>Amityville</location_municipality> </row> <row id="3"> <id_bigint>114</id_bigint> <meeting_name>Un Nuevo Empezar</meeting_name> <location_municipality>New York</location_municipality> </row> · · ·
JSON Examples
- Get All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday.
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/json/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19
- Response:
-
[ {"id_bigint":"24","worldid_mixed":"00014731","shared_group_id_bigint":"","service_body_bigint":"1005","weekday_tinyint":"1","start_time":"16:15:00","duration_time":"01:30:00","formats":"O,RF","lang_enum":"en","longitude":"-73.905834","latitude":"40.838762","email_contact":"","meeting_name":"Meditation on Sundays","location_text":"Our Lady of Victory Church","location_info":"@171st St","location_street":"1512 Webster Ave","location_city_subsection":"Bronx","location_neighborhood":"Claremont","location_municipality":"New York","location_sub_province":"Bronx","location_province":"NY","location_postal_code_1":"10457","location_nation":"USA"} {"id_bigint":"346","worldid_mixed":"00113665","shared_group_id_bigint":"","service_body_bigint":"1010","weekday_tinyint":"1","start_time":"16:30:00","duration_time":"01:30:00","formats":"C,JT,WC,BK","lang_enum":"en","longitude":"-73.976946","latitude":"40.724846","email_contact":"","meeting_name":"Just for Today","location_text":"Housing Works, Ground Floor","location_info":"Btwn Aves C&D","location_street":"743 E 9th St","location_city_subsection":"Manhattan","location_neighborhood":"East Village","location_municipality":"New York","location_sub_province":"New York","location_province":"NY","location_postal_code_1":"10009","location_nation":"USA"} {"id_bigint":"803","worldid_mixed":"00010448","shared_group_id_bigint":"","service_body_bigint":"1001","weekday_tinyint":"1","start_time":"17:00:00","duration_time":"02:00:00","formats":"O,D,St","lang_enum":"en","longitude":"-73.4077826142311","latitude":"40.7096557895169","email_contact":"","meeting_name":"Surrender On Sunday","location_text":"Community Center (On East Street)","location_info":"","location_street":"East St. at Cedar St.","location_city_subsection":"","location_neighborhood":"","location_municipality":"Amityville","location_sub_province":"Suffolk","location_province":"NY","location_postal_code_1":"11701","location_nation":"USA","comments":"Last Sunday of every month is a Step meeting."} {"id_bigint":"114","worldid_mixed":"00000000","shared_group_id_bigint":"","service_body_bigint":"1015","weekday_tinyint":"1","start_time":"17:00:00","duration_time":"01:30:00","formats":"O,ES,St","lang_enum":"es","longitude":"-73.881634","latitude":"40.880458","email_contact":"","meeting_name":"Un Nuevo Empezar","location_text":"North Central Bronx Hosp, Rm 14B07","location_info":"Btwn E 210th St & Dekalb Ave","location_street":"3424 Kossuth Ave","location_city_subsection":"Bronx","location_neighborhood":"Williamsbridge","location_municipality":"New York","location_sub_province":"Bronx","location_province":"NY","location_postal_code_1":"10467","location_nation":"USA","comments":"","train_lines":"Tren 4 hasta Mosholu Pkwy","bus_lines":"Bus Bx 10 hasta Mosholu Pkwy"} · · ·
Note that the actual response data is returned as optimized JSON, which means that everything is crammed into one line. This has been formatted for your reading pleasure. The JSON response is an array, with each element being a JSON object representing one meeting, and with named data members. Also note that not all rows have all data members. If data is not supplied for a data member, the data member is not provided at all, as opposed to an empty data member.
- Get All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday, and only return the town and meeting name.
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/json/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19 &data_field_key=location_municipality,meeting_name
- Response:
-
[ {"meeting_name":"Meditation on Sundays","location_municipality":"New York"}, {"meeting_name":"Just for Today","location_municipality":"New York"}, {"meeting_name":"Surrender On Sunday","location_municipality":"Amityville"}, {"meeting_name":"Un Nuevo Empezar","location_municipality":"New York"} · · ·
- Get All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday, and only return the meeting ID, town and meeting name.
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/json/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19 &data_field_key=location_municipality,meeting_name,id_bigint
- Response:
-
[ {"id_bigint":"24","meeting_name":"Meditation on Sundays","location_municipality":"New York"}, {"id_bigint":"346","meeting_name":"Just for Today","location_municipality":"New York"}, {"id_bigint":"803","meeting_name":"Surrender On Sunday","location_municipality":"Amityville"}, {"id_bigint":"114","meeting_name":"Un Nuevo Empezar","location_municipality":"New York"} · · ·
Getting The Formats Used In Meeting Searches
We also have two extra parameters that can be added to the
switcher:
and
. These will add a list of all the formats used in the returned results (the
switcher always returns all possible formats on the server; whether or not they are actually used by any meetings in the response). If you add
to the URI, XML and JSON results will add a “formats” section to the result. CSV searches will ignore this parameter. If you add
to the URI, then all of the results will include only the formats.
NOTE: In JSON, specifying
will cause the response format to change, with an object containing two arrays (“meetings” and “formats”) returned, as opposed to the single array of meetings.
- Get Only the Formats for All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday, in CSV Format (Can Only Use
get_formats_only
):
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/csv/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19&get_formats_only
- Response:
-
"key_string","name_string","description_string","lang","id" "O","Open","This meeting is open to addicts and non-addicts alike. All are welcome.","en","17" "RF","Rotating Format","This meeting has a format that changes for each meeting.","en","19" "C","Closed","This meeting is closed to non-addicts. You should attend only if you believe that you may have a problem with substance abuse.","en","4" "JT","Just for Today","This meeting is focused on discussion of the Just For Today text.","en","14" · · · "YP","Young People","This meeting is focused on the needs of younger members of NA.","en","34" "SC","Surveillance Cameras","This meeting is held in a facility that has surveillance cameras.","en","21" "So","Speaker Only","This meeting is a speaker-only meeting. Other attendees do not participate in the discussion.","en","26"
- Get the Meeting Data and the Formats for All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday in XML Format:
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/xml/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19&get_used_formats
- Response (Remember that the real response is optimized. This formatting is imposed):
-
<?xml version="1.0" encoding="UTF-8"?> <meetings xmlns="https://old.bmlt.app" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="https://old.bmlt.app https://old.bmlt.app/stable/main_server/client_interface/xsd/GetSearchResults.php"> <row id="0"> <id_bigint>24</id_bigint> <worldid_mixed>00014731</worldid_mixed> <service_body_bigint>1005</service_body_bigint> <weekday_tinyint>1</weekday_tinyint> <start_time>16:15:00</start_time> <duration_time>01:30:00</duration_time> <formats>O,RF</formats> <lang_enum>en</lang_enum> <longitude>-73.905834</longitude> <latitude>40.838762</latitude> <meeting_name>Meditation on Sundays</meeting_name> <location_text>Our Lady of Victory Church</location_text> <location_info>@171st St</location_info> <location_street>1512 Webster Ave</location_street> <location_city_subsection>Bronx</location_city_subsection> <location_neighborhood>Claremont</location_neighborhood> <location_municipality>New York</location_municipality> <location_sub_province>Bronx</location_sub_province> <location_province>NY</location_province> <location_postal_code_1>10457</location_postal_code_1> <location_nation>USA</location_nation> </row> <row id="1"> <id_bigint>346</id_bigint> <worldid_mixed>00113665</worldid_mixed> <service_body_bigint>1010</service_body_bigint> <weekday_tinyint>1</weekday_tinyint> <start_time>16:30:00</start_time> <duration_time>01:30:00</duration_time> <formats>C,JT,WC,BK</formats> <lang_enum>en</lang_enum> <longitude>-73.976946</longitude> <latitude>40.724846</latitude> <meeting_name>Just for Today</meeting_name> <location_text>Housing Works</location_text> <location_info>Btwn Ave. C & D</location_info> <location_street>743 E. 9th St.</location_street> <location_city_subsection>Manhattan</location_city_subsection> <location_neighborhood>East Village</location_neighborhood> <location_municipality>New York</location_municipality> <location_sub_province>New York</location_sub_province> <location_province>NY</location_province> <location_postal_code_1>10009</location_postal_code_1> <location_nation>USA</location_nation> </row> <row id="2"> <id_bigint>1219</id_bigint> <service_body_bigint>1003</service_body_bigint> <weekday_tinyint>1</weekday_tinyint> <start_time>17:00:00</start_time> <duration_time>00:00:00</duration_time> <formats>St,Tr</formats> <lang_enum>en</lang_enum> <longitude>-72.139105796814</longitude> <latitude>40.9760749361243</latitude> <meeting_name>How & Why</meeting_name> <location_text>St Peter's R C church</location_text> <location_street>298 montauk hgwy ( main st)</location_street> <location_municipality>Amagansett</location_municipality> <location_province>N Y</location_province> <location_postal_code_1>11930</location_postal_code_1> </row> · · · <row id="195"> <id_bigint>405</id_bigint> <worldid_mixed>00012356</worldid_mixed> <service_body_bigint>1008</service_body_bigint> <weekday_tinyint>7</weekday_tinyint> <start_time>18:30:00</start_time> <duration_time>01:30:00</duration_time> <formats>C,B</formats> <lang_enum>en</lang_enum> <longitude>-73.936018</longitude> <latitude>40.830822</latitude> <meeting_name>It Can Be Done</meeting_name> <location_text>Ready, Willing & Able - Harlem</location_text> <location_info>@156th St</location_info> <location_street>2960 Frederick Douglass Blvd</location_street> <location_city_subsection>Manhattan</location_city_subsection> <location_neighborhood>W 150s</location_neighborhood> <location_municipality>New York</location_municipality> <location_sub_province>New York</location_sub_province> <location_province>NY</location_province> <location_postal_code_1>10039</location_postal_code_1> <location_nation>USA</location_nation> </row> <row id="196"> <id_bigint>194</id_bigint> <worldid_mixed>00127945</worldid_mixed> <service_body_bigint>1009</service_body_bigint> <weekday_tinyint>7</weekday_tinyint> <start_time>18:30:00</start_time> <duration_time>01:30:00</duration_time> <formats>C,B</formats> <lang_enum>en</lang_enum> <longitude>-73.921822</longitude> <latitude>41.706256</latitude> <meeting_name>Saturday Night Live</meeting_name> <location_text>St. Paul's Church</location_text> <location_info>St Paul's Church</location_info> <location_street>161 Mansion St.</location_street> <location_municipality>Poughkeepsie</location_municipality> <location_sub_province>Dutchess</location_sub_province> <location_province>NY</location_province> <location_postal_code_1>12601</location_postal_code_1> <location_nation>USA</location_nation> </row> <row id="197"> <id_bigint>565</id_bigint> <worldid_mixed>00000000</worldid_mixed> <service_body_bigint>1012</service_body_bigint> <weekday_tinyint>7</weekday_tinyint> <start_time>18:45:00</start_time> <duration_time>01:30:00</duration_time> <formats>O,B</formats> <lang_enum>en</lang_enum> <longitude>-74.032946</longitude> <latitude>41.166969</latitude> <meeting_name>Staying Alive</meeting_name> <location_text>Pomona Health Complex, Building A</location_text> <location_info>@Rt 45 (Near Pomona Rd)</location_info> <location_street>## Medical Park Dr</location_street> <location_municipality>Pomona</location_municipality> <location_sub_province>Rockland</location_sub_province> <location_province>NY</location_province> <location_postal_code_1>10970</location_postal_code_1> <location_nation>USA</location_nation> </row> <formats> <row id="198"> <key_string>O</key_string> <name_string>Open</name_string> <description_string>This meeting is open to addicts and non-addicts alike. All are welcome.</description_string> <lang>en</lang> <id>17</id> </row> <row id="199"> <key_string>RF</key_string> <name_string>Rotating Format</name_string> <description_string>This meeting has a format that changes for each meeting.</description_string> <lang>en</lang> <id>19</id> </row> <row id="200"> <key_string>C</key_string> <name_string>Closed</name_string> <description_string>This meeting is closed to non-addicts. You should attend only if you believe that you may have a problem with substance abuse.</description_string> <lang>en</lang> <id>4</id> </row> <row id="201"> <key_string>JT</key_string> <name_string>Just for Today</name_string> <description_string>This meeting is focused on discussion of the Just For Today text.</description_string> <lang>en</lang> <id>14</id> </row> · · · <row id="228"> <key_string>YP</key_string> <name_string>Young People</name_string> <description_string>This meeting is focused on the needs of younger members of NA.</description_string> <lang>en</lang> <id>34</id> </row> <row id="229"> <key_string>SC</key_string> <name_string>Surveillance Cameras</name_string> <description_string>This meeting is held in a facility that has surveillance cameras.</description_string> <lang>en</lang> <id>21</id> </row> <row id="230"> <key_string>So</key_string> <name_string>Speaker Only</name_string> <description_string>This meeting is a speaker-only meeting. Other attendees do not participate in the discussion.</description_string> <lang>en</lang> <id>26</id> </row> </formats> </meetings>
- Get Only the Formats for All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday in XML Format:
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/xml/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19&get_formats_only
- Response (Remember that the real response is optimized. This formatting is imposed):
-
<?xml version="1.0" encoding="UTF-8"?> <formats xmlns="https://old.bmlt.app" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="https://old.bmlt.app https://old.bmlt.app/stable/main_server/client_interface/xsd/GetFormats.php"> <row id="198"> <key_string>O</key_string> <name_string>Open</name_string> <description_string>This meeting is open to addicts and non-addicts alike. All are welcome.</description_string> <lang>en</lang> <id>17</id> </row> <row id="199"> <key_string>RF</key_string> <name_string>Rotating Format</name_string> <description_string>This meeting has a format that changes for each meeting.</description_string> <lang>en</lang> <id>19</id> </row> <row id="200"> <key_string>C</key_string> <name_string>Closed</name_string> <description_string>This meeting is closed to non-addicts. You should attend only if you believe that you may have a problem with substance abuse.</description_string> <lang>en</lang> <id>4</id> </row> <row id="201"> <key_string>JT</key_string> <name_string>Just for Today</name_string> <description_string>This meeting is focused on discussion of the Just For Today text.</description_string> <lang>en</lang> <id>14</id> </row> · · · <row id="228"> <key_string>YP</key_string> <name_string>Young People</name_string> <description_string>This meeting is focused on the needs of younger members of NA.</description_string> <lang>en</lang> <id>34</id> </row> <row id="229"> <key_string>SC</key_string> <name_string>Surveillance Cameras</name_string> <description_string>This meeting is held in a facility that has surveillance cameras.</description_string> <lang>en</lang> <id>21</id> </row> <row id="230"> <key_string>So</key_string> <name_string>Speaker Only</name_string> <description_string>This meeting is a speaker-only meeting. Other attendees do not participate in the discussion.</description_string> <lang>en</lang> <id>26</id> </row> </formats>
- Get the Meeting Data and the Formats for All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday in JSON Format:
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/json/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19&get_used_formats
- Response (Remember that the real response is optimized. This formatting is imposed).
- Also, note that the response is broken into two objects, instead of the simple array:
-
{ "meetings":[ {"id_bigint":"24","worldid_mixed":"00014731","shared_group_id_bigint":"","service_body_bigint":"1005","weekday_tinyint":"1","start_time":"16:15:00","duration_time":"01:30:00","formats":"O,RF","lang_enum":"en","longitude":"-73.905834","latitude":"40.838762","email_contact":"","distance_in_km":"","distance_in_miles":"","meeting_name":"Meditation on Sundays","location_text":"Our Lady of Victory Church","location_info":"@171st St","location_street":"1512 Webster Ave","location_city_subsection":"Bronx","location_neighborhood":"Claremont","location_municipality":"New York","location_sub_province":"Bronx","location_province":"NY","location_postal_code_1":"10457","location_nation":"USA"}, {"id_bigint":"346","worldid_mixed":"00113665","shared_group_id_bigint":"","service_body_bigint":"1010","weekday_tinyint":"1","start_time":"16:30:00","duration_time":"01:30:00","formats":"C,JT,WC,BK","lang_enum":"en","longitude":"-73.976946","latitude":"40.724846","email_contact":"","distance_in_km":"","distance_in_miles":"","meeting_name":"Just for Today","location_text":"Housing Works","location_info":"Btwn Ave. C & D","location_street":"743 E. 9th St.","location_city_subsection":"Manhattan","location_neighborhood":"East Village","location_municipality":"New York","location_sub_province":"New York","location_province":"NY","location_postal_code_1":"10009","location_nation":"USA"}, {"id_bigint":"1219","worldid_mixed":"","shared_group_id_bigint":"","service_body_bigint":"1003","weekday_tinyint":"1","start_time":"17:00:00","duration_time":"00:00:00","formats":"St,Tr","lang_enum":"en","longitude":"-72.139105796814","latitude":"40.9760749361243","email_contact":"","distance_in_km":"","distance_in_miles":"","meeting_name":"How & Why","location_text":"St Peter's R C church","location_info":"","location_street":"298 montauk hgwy ( main st)","location_city_subsection":"","location_neighborhood":"","location_municipality":"Amagansett","location_sub_province":"","location_province":"N Y","location_postal_code_1":"11930"}, {"id_bigint":"803","worldid_mixed":"00010448","shared_group_id_bigint":"","service_body_bigint":"1001","weekday_tinyint":"1","start_time":"17:00:00","duration_time":"02:00:00","formats":"O,D,St","lang_enum":"en","longitude":"-73.4077826142311","latitude":"40.7096557895169","email_contact":"","distance_in_km":"","distance_in_miles":"","meeting_name":"Surrender On Sunday","location_text":"Community Center (On East Street)","location_info":"","location_street":"East St. at Cedar St.","location_city_subsection":"","location_neighborhood":"","location_municipality":"Amityville","location_sub_province":"Suffolk","location_province":"NY","location_postal_code_1":"11701","location_nation":"USA","comments":"Last Sunday of every month is a Step meeting."}, · · · {"id_bigint":"405","worldid_mixed":"00012356","shared_group_id_bigint":"","service_body_bigint":"1008","weekday_tinyint":"7","start_time":"18:30:00","duration_time":"01:30:00","formats":"C,B","lang_enum":"en","longitude":"-73.936018","latitude":"40.830822","email_contact":"","distance_in_km":"","distance_in_miles":"","meeting_name":"It Can Be Done","location_text":"Ready, Willing & Able - Harlem","location_info":"@156th St","location_street":"2960 Frederick Douglass Blvd","location_city_subsection":"Manhattan","location_neighborhood":"W 150s","location_municipality":"New York","location_sub_province":"New York","location_province":"NY","location_postal_code_1":"10039","location_nation":"USA"}, {"id_bigint":"194","worldid_mixed":"00127945","shared_group_id_bigint":"","service_body_bigint":"1009","weekday_tinyint":"7","start_time":"18:30:00","duration_time":"01:30:00","formats":"C,B","lang_enum":"en","longitude":"-73.921822","latitude":"41.706256","email_contact":"","distance_in_km":"","distance_in_miles":"","meeting_name":"Saturday Night Live","location_text":"St. Paul's Church","location_info":"St Paul's Church","location_street":"161 Mansion St.","location_city_subsection":"","location_neighborhood":"","location_municipality":"Poughkeepsie","location_sub_province":"Dutchess","location_province":"NY","location_postal_code_1":"12601","location_nation":"USA"}, {"id_bigint":"565","worldid_mixed":"00000000","shared_group_id_bigint":"","service_body_bigint":"1012","weekday_tinyint":"7","start_time":"18:45:00","duration_time":"01:30:00","formats":"O,B","lang_enum":"en","longitude":"-74.032946","latitude":"41.166969","email_contact":"","distance_in_km":"","distance_in_miles":"","meeting_name":"Staying Alive","location_text":"Pomona Health Complex, Building A","location_info":"@Rt 45 (Near Pomona Rd)","location_street":"## Medical Park Dr","location_city_subsection":"","location_neighborhood":"","location_municipality":"Pomona","location_sub_province":"Rockland","location_province":"NY","location_postal_code_1":"10970","location_nation":"USA"} ], "formats":[ {"key_string":"O","name_string":"Open","description_string":"This meeting is open to addicts and non-addicts alike. All are welcome.","lang":"en","id":"17"}, {"key_string":"RF","name_string":"Rotating Format","description_string":"This meeting has a format that changes for each meeting.","lang":"en","id":"19"}, {"key_string":"C","name_string":"Closed","description_string":"This meeting is closed to non-addicts. You should attend only if you believe that you may have a problem with substance abuse.","lang":"en","id":"4"}, {"key_string":"JT","name_string":"Just for Today","description_string":"This meeting is focused on discussion of the Just For Today text.","lang":"en","id":"14"}, · · · {"key_string":"YP","name_string":"Young People","description_string":"This meeting is focused on the needs of younger members of NA.","lang":"en","id":"34"}, {"key_string":"SC","name_string":"Surveillance Cameras","description_string":"This meeting is held in a facility that has surveillance cameras.","lang":"en","id":"21"}, {"key_string":"So","name_string":"Speaker Only","description_string":"This meeting is a speaker-only meeting. Other attendees do not participate in the discussion.","lang":"en","id":"26"} ] }
- Get Only the Formats for All Meetings In the Database That Start At or After 4PM, and Before or At 7PM on Any Weekday in JSON Format:
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/json/?switcher=GetSearchResults&sort_key=time&StartsAfterH=16&StartsBeforeH=19&get_formats_only
- Response (Remember that the real response is optimized. This formatting is imposed):
-
[ {"key_string":"O","name_string":"Open","description_string":"This meeting is open to addicts and non-addicts alike. All are welcome.","lang":"en","id":"17"}, {"key_string":"RF","name_string":"Rotating Format","description_string":"This meeting has a format that changes for each meeting.","lang":"en","id":"19"}, {"key_string":"C","name_string":"Closed","description_string":"This meeting is closed to non-addicts. You should attend only if you believe that you may have a problem with substance abuse.","lang":"en","id":"4"}, {"key_string":"JT","name_string":"Just for Today","description_string":"This meeting is focused on discussion of the Just For Today text.","lang":"en","id":"14"}, · · · {"key_string":"YP","name_string":"Young People","description_string":"This meeting is focused on the needs of younger members of NA.","lang":"en","id":"34"}, {"key_string":"SC","name_string":"Surveillance Cameras","description_string":"This meeting is held in a facility that has surveillance cameras.","lang":"en","id":"21"}, {"key_string":"So","name_string":"Speaker Only","description_string":"This meeting is a speaker-only meeting. Other attendees do not participate in the discussion.","lang":"en","id":"26"} ]
Getting Changes
We also have the ability to get a list of changes to meetings that occurred between two dates (or between one date and now, or between the start of the server and another date).
NOTE: The dates are inclusive, and ignore times (Hours and minutes will be ignored). They are from Midnight (00:00:00) of the “start” date (if provided, otherwise from the initiation of the server), to 11:59PM (23:59:59) of the end date (if provided, otherwise to the last change before the call was made). The most recent changes are on top.
This capability is available in CSV, XML or JSON. You get the list of changes by using a different
value: ”
.” You can optionally supply a
and
parameter (Use YYYY-MM-DD format, with leading zeroes).
- Get All Changes In the Database That Occurred After September 1st, 2010, and before December 31, 2010 (Last Quarter of 2010), in CSV format:
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/csv/?switcher=GetChanges&start_date=2010-09-01&end_date=2010-12-31
- Response:
-
"date_int","date_string","change_type","meeting_id","meeting_name","user_id","user_name","details" "1293839136","6:45 PM, 12/31/2010","comdef_change_type_change","915","Recovery Today","21","Queens Area Service Administrator","The meeting format was changed from 'O, St' to 'C, St'." "1293589842","9:30 PM, 12/28/2010","comdef_change_type_change","1173","The Place To Be","2","Suffolk Area Service Administrator","The meeting duration was changed from '0:00' to '1:45'." "1293589810","9:30 PM, 12/28/2010","comdef_change_type_change","1173","The Place To Be","2","Suffolk Area Service Administrator","" · · · "1283556074","7:21 PM, 9/3/2010","comdef_change_type_change","1112","Diversity is Our Strength","17","Open Arms Area Service Administrator","The meeting longitude was changed from '-74.392311573029' to '-74.395380020142'. The meeting latitude was changed from '41.715387662665' to '41.714458653529'." "1283556028","7:20 PM, 9/3/2010","comdef_change_type_change","1112","Diversity is Our Strength","17","Open Arms Area Service Administrator","The meeting start time was changed from '22:00' to '19:30'. The meeting duration was changed from '23:00' to '21:00'." "1283555973","7:19 PM, 9/3/2010","comdef_change_type_change","1112","Diversity is Our Strength","17","Open Arms Area Service Administrator","The meeting start time was changed from '12:00' to '22:00'. The meeting duration was changed from '1:00' to '23:00'. Street Address was changed from '104 Center St.' to '40 Market St.'. Location Name was added as 'St. John's Episcopal Church' ."
- The same thing, in XML format:
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/xml/?switcher=GetChanges&start_date=2010-09-01&end_date=2010-12-31
- Response (Remember that the real response is optimized. This formatting is imposed):
-
<changes xsi:schemaLocation="https://old.bmlt.app https://old.bmlt.app/stable/main_server/client_interface/xsd/GetChanges.php" xmlns="https://old.bmlt.app" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <row id="0"> <date_int>1293839136</date_int> <date_string>6:45 PM, 12/31/2010</date_string> <change_type>comdef_change_type_change</change_type> <meeting_id>915</meeting_id> <meeting_name>Recovery Today</meeting_name> <user_id>21</user_id> <user_name>Queens Area Service Administrator</user_name> <details>The meeting format was changed from 'O, St' to 'C, St'.</details> </row> <row id="1"> <date_int>1293589842</date_int> <date_string>9:30 PM, 12/28/2010</date_string> <change_type>comdef_change_type_change</change_type> <meeting_id>1173</meeting_id> <meeting_name>The Place To Be</meeting_name> <user_id>2</user_id> <user_name>Suffolk Area Service Administrator</user_name> <details>The meeting duration was changed from '0:00' to '1:45'.</details> </row> <row id="2"> <date_int>1293589810</date_int> <date_string>9:30 PM, 12/28/2010</date_string> <change_type>comdef_change_type_change</change_type> <meeting_id>1173</meeting_id> <meeting_name>The Place To Be</meeting_name> <user_id>2</user_id> <user_name>Suffolk Area Service Administrator</user_name> </row> <row id="3"> <date_int>1293589786</date_int> <date_string>9:29 PM, 12/28/2010</date_string> <change_type>comdef_change_type_change</change_type> <meeting_id>1173</meeting_id> <meeting_name>The Place To Be</meeting_name> <user_id>2</user_id> <user_name>Suffolk Area Service Administrator</user_name> <details>County was added as 'Suffolk' .</details> </row> · · · <row id="247"> <date_int>1283556074</date_int> <date_string>7:21 PM, 9/3/2010</date_string> <change_type>comdef_change_type_change</change_type> <meeting_id>1112</meeting_id> <meeting_name>Diversity is Our Strength</meeting_name> <user_id>17</user_id> <user_name>Open Arms Area Service Administrator</user_name> <details>The meeting longitude was changed from '-74.392311573029' to '-74.395380020142'. The meeting latitude was changed from '41.715387662665' to '41.714458653529'.</details> </row> <row id="248"> <date_int>1283556028</date_int> <date_string>7:20 PM, 9/3/2010</date_string> <change_type>comdef_change_type_change</change_type> <meeting_id>1112</meeting_id> <meeting_name>Diversity is Our Strength</meeting_name> <user_id>17</user_id> <user_name>Open Arms Area Service Administrator</user_name> <details>The meeting start time was changed from '22:00' to '19:30'. The meeting duration was changed from '23:00' to '21:00'.</details> </row> <row id="249"> <date_int>1283555973</date_int> <date_string>7:19 PM, 9/3/2010</date_string> <change_type>comdef_change_type_change</change_type> <meeting_id>1112</meeting_id> <meeting_name>Diversity is Our Strength</meeting_name> <user_id>17</user_id> <user_name>Open Arms Area Service Administrator</user_name> <details>The meeting start time was changed from '12:00' to '22:00'. The meeting duration was changed from '1:00' to '23:00'. Street Address was changed from '104 Center St.' to '40 Market St.'. Location Name was added as 'St. John's Episcopal Church' .</details> </row> </changes>
- The same thing, in JSON format:
- URI:
- https://old.bmlt.app/stable/main_server/client_interface/json/?switcher=GetChanges&start_date=2010-09-01&end_date=2010-12-31
- Response (Remember that the real response is optimized. This formatting is imposed):
-
[ {"date_int":"1293839136","date_string":"6:45 PM, 12\/31\/2010","change_type":"comdef_change_type_change","meeting_id":"915","meeting_name":"Recovery Today","user_id":"21","user_name":"Queens Area Service Administrator","details":"The meeting format was changed from 'O, St' to 'C, St'."}, {"date_int":"1293589842","date_string":"9:30 PM, 12\/28\/2010","change_type":"comdef_change_type_change","meeting_id":"1173","meeting_name":"The Place To Be","user_id":"2","user_name":"Suffolk Area Service Administrator","details":"The meeting duration was changed from '0:00' to '1:45'."}, {"date_int":"1293589810","date_string":"9:30 PM, 12\/28\/2010","change_type":"comdef_change_type_change","meeting_id":"1173","meeting_name":"The Place To Be","user_id":"2","user_name":"Suffolk Area Service Administrator"}, · · · {"date_int":"1283556074","date_string":"7:21 PM, 9\/3\/2010","change_type":"comdef_change_type_change","meeting_id":"1112","meeting_name":"Diversity is Our Strength","user_id":"17","user_name":"Open Arms Area Service Administrator","details":"The meeting longitude was changed from '-74.392311573029' to '-74.395380020142'. The meeting latitude was changed from '41.715387662665' to '41.714458653529'."}, {"date_int":"1283556028","date_string":"7:20 PM, 9\/3\/2010","change_type":"comdef_change_type_change","meeting_id":"1112","meeting_name":"Diversity is Our Strength","user_id":"17","user_name":"Open Arms Area Service Administrator","details":"The meeting start time was changed from '22:00' to '19:30'. The meeting duration was changed from '23:00' to '21:00'."}, {"date_int":"1283555973","date_string":"7:19 PM, 9\/3\/2010","change_type":"comdef_change_type_change","meeting_id":"1112","meeting_name":"Diversity is Our Strength","user_id":"17","user_name":"Open Arms Area Service Administrator","details":"The meeting start time was changed from '12:00' to '22:00'. The meeting duration was changed from '1:00' to '23:00'. Street Address was changed from '104 Center St.' to '40 Market St.'. Location Name was added as 'St. John's Episcopal Church' ."} ]