What does "*_LOOKUP_*" mean in the database

Need help Database
1

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

1348695171700984260__LOOKUP__1502310920222x668615033384412500

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

1502733724830x738194115925580300

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

image

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

2

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

3

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

#!/usr/bin/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")
file.write(data)
file.close()
print "</html>"
4

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.

2 Likes
5

That makes sense. Thanks.