Hi, everyone! I had a question about querying the Core Places data set. I noticed that the endpoint fields changed recently (“brands” is now split into “brand_id” and “brand_name”). Since then, I have been getting 400 bad request errors, when using the API. Would someone be able to help me figure out what’s going on, and potentially help me fix it? Thank you!
This topic was automatically generated from Slack. You can find the original thread here.
Thank you!
@Michael_Gallagher_SafeGraph Thanks for getting back to me! That’s good to know! I am still using /v1 endpoint in my requests, but I am still getting the 400 bad requests error. This set up was working last week, the reason I changed it is because I thought queries had to be structured differently! Any idea what must be going on? I wasn’t getting bad request errors with the same code last week! Thank you!
hi aadit. can you post the query and perhaps the code snippet? thanks
The build_queries function takes “batch_placekeys” and “core_places_var” as inputs.
Here’s an example of batch_placekeys:
[1] "[\"zzw-222@undefined ts-2dw-gc5\",\"226-223@undefined ts-3n7-kzz\",\"223@undefined zb-vp8-h3q\",\"225-222@undefined ts-3mf-5zz\",\"zzw-222@undefined tt-pg8-qcq\",\"zzw-222@undefined ts-s2x-zs5\",\"222@undefined sc-r8m-dvz\",\"225-223@undefined ts-yf4-ffz\",\"222-222@undefined z9-brk-7wk\",\"222-222@undefined ts-3mb-68v\",\"zzw-222@undefined tt-pfq-3nq\",\"zzw-222@undefined ts-2d4-y5f\",\"225-222@undefined ts-d5n-k9f\",\"zzy-224@undefined tt-pgs-n89\",\"22c-222@undefined ts-3mz-tsq\",\"222-222@undefined ts-zc9-rp9\",\"223@undefined zb-x66-99f\",\"222-223@undefined zb-xgk-qs5\",\"222-223@undefined zb-xj5-75z\",\"222@undefined ts-zfr-j9z\",\"224@undefined zb-xkq-jvz\",\"224-222@undefined ts-ckc-q2k\",\"zzw-223@undefined ts-zr8-6rk\",\"222-224@undefined ts-w4q-jsq\",\"222-223@undefined zb-xds-wc5\",\"226-223@undefined zb-xn5-nyv\",\"224-223@undefined zb-xns-6x5\",\"222@undefined ts-ckg-5cq\",\"227-222@undefined ts-zbg-zfz\",\"224-223@undefined z9-swy-djv\",\"222-222@undefined zb-265-fxq\",\"222-222@undefined z9-r79-fxq\",\"224@undefined z9-sqt-qpv\",\"zzy-226@undefined z9-jkc-v75\",\"222-224@undefined tt-7wc-kmk\",\"225-223@undefined ts-zfq-wff\",\"224@undefined ts-zfw-d9z\",\"224@undefined zb-wwg-6kz\",\"22f-222@undefined zb-xkn-zfz\",\"zzw-222@undefined zb-xb5-skf\",\"222-225@undefined zb-xfn-z4v\",\"224-223@undefined zb-xbg-mff\",\"224@undefined zb-xdv-h5z\",\"zzw-223@undefined ts-3hc-hwk\",\"222-222@undefined zb-vng-mrk\",\"222-224@undefined z9-m3k-j5f\",\"zzw-222@undefined ts-zd6-nqz\",\"224@undefined ts-3nn-vzz\",\"zzw-226@undefined zb-x4w-2c5\",\"222-223@undefined zb-xfm-6kz\",\"222@undefined zb-v7g-9mk\",\"223@undefined zb-xj7-yn5\",\"zzw-224@undefined tg-hvr-7nq\",\"222-22b@undefined th-742-4d9\",\"224-223@undefined zb-t2g-jgk\",\"223-222@undefined ts-3pj-vj9\",\"227@undefined zb-xbg-8d9\",\"222@undefined yz-txz-5cq\",\"zzw-222@undefined sc-h34-wx5\",\"22h-222@undefined sc-xqj-85f\",\"22f@undefined ts-d35-7qz\",\"22c@undefined zb-xcp-fzz\",\"223@undefined zb-x3r-2ff\",\"223-222@undefined ts-zg4-8sq\",\"222-222@undefined z9-7pm-ffz\",\"224@undefined zb-x5b-mtv\",\"228-223@undefined ts-zbg-mff\",\"222@undefined ts-zy4-f75\",\"222-222@undefined ts-wg4-f4v\",\"222@undefined zb-t9j-c89\",\"226-222@undefined zb-t2h-grk\",\"zzw-226@undefined ts-zcm-xkf\",\"222@undefined ts-79t-mkz\",\"222-222@undefined zb-wtn-26k\",\"222-222@undefined ts-d5t-kzz\",\"222-223@undefined zb-ww7-8vz\",\"222-222@undefined z9-hz5-rzf\",\"222-224@undefined zb-xdr-hbk\",\"225-223@undefined ts-w49-vs5\",\"222@undefined ts-w3x-btv\",\"222-222@undefined zb-wtr-xh5\",\"22f-222@undefined ts-zrm-b49\",\"223-225@undefined zb-266-hqz\",\"222@undefined zb-26m-vs5\",\"zzw-222@undefined zb-xgz-fpv\",\"222-222@undefined tg-hvr-7qz\",\"228@undefined tt-pgs-cwk\",\"zzw-223@undefined zb-xc6-t9z\",\"zzy-223@undefined ts-xxn-47q\",\"222@undefined zb-xg4-gc5\",\"226@undefined ts-zhv-gx5\",\"zzw-222@undefined zb-v5s-mzf\",\"223-225@undefined zb-266-hqz\",\"zzw-222@undefined ts-fcp-swk\",\"22g@undefined ts-wz9-tvz\",\"zzw-222@undefined zb-x2m-3t9\",\"zzw-222@undefined ts-zff-xnq\",\"zzw-224@undefined ts-zcv-yy9\",\"222@undefined ts-3mq-xyv\"]"
Here’s an example of core_places_var is core_places .
Does this help? Thank you!
Oh, that makes sense! I will try it without the backslashes! Thank you so much for your help!