What does "*_LOOKUP_*" mean in the database

I’m pulling data out of Bubble to a database on another server. When I use the GET data API some of the references in the array look like this


That’s in the “created by” field but it doesn’t seem to correspond to any users. Even if I search for just the id at the end it doesn’t turn up any users. As far as I can tell, the id for the user who created this record is this


There are other records with that weird code. They all have the same starting numbers


How do I turn this “lookup” into the correct id for a user in the user table? @emmanuel

Can you share a Curl call the returns this? This shouldn’t happen.

I’ve never used Curl. I got this result after using this in Python

print "content-type: text/html\n\n"
print "<html>"
import re
from urllib2 import urlopen
from time import gmtime, strftime
import MySQLdb
import MySQLdb.cursors as cursors
tableName = "entry"
cursorIndex = 0
data = urlopen("https://track-well.bubbleapps.io/api/1.1/obj/" + tableName + "?api_token=1c7816078525520a65e1e1ffad5772e7&cursor=" + str(cursorIndex)).read()
file = open("files/" + tableName + "_" + str(cursorIndex) + ".txt", "wb")
print "</html>"

The issue here is that the choser_user_user ID is ‘1502310920222x668615033384412500’ and this user is not in the database any more (it was probably deleted). We’ll fix the API so that it returns an empty value instead.


That makes sense. Thanks.