ContributionsMost RecentMost LikesSolutionsCan't use pandas.read_json() with new QB RESTFul APIHi, I try to use inbuilt pandas read_json with new RESTFull QB API, but it doesn't work, even though I tried every orient and typ. https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_json.html Using the most fitting orient 'split' : dict like {index->[index],columns->[columns],data->[values]} I getValueError: JSON data had unexpected key(s): fields, metadata I've already came up with a workaround using pd.DataFrame.from_dict(r.json()['data']).applymap(lambdax:list(x.values())[0]) but it's not fully functional. Any ideas, what am I doing wrong? Maybe someone already had experience processing QB JSON in Python... ------------------------------ Alexander Berezovskiy ------------------------------Re: Automation to add record to another table if it does not existChecked the table now and there are just two fields marked as "unique":Destination ID(Key field)andRecord ID#which I cannot unmark as "unique". Automation to add record to another table if it does not existHello, colleagues, I have two tables: Loads Fields: Load ID (Key field) Destination ID ... others Destination IDs MasterData Destination ID(Key field) Destination name ... others The data is added to "Loads" table in batches. As soon as Load ID with Destination ID not yet present inDestination IDs MasterDataappears (in Loads table) I need to add it (toDestination IDs MasterData table). In order to do so I made a relation, which looks upDestination ID in "MD" tablebyDestination ID in "Loads" and then compares them in a formula, let's call it "DestinationExists?". If they are equal, it returns "True". Then I made an automation, which is triggered upon addition or modification of any field in "Loads" table, filtered by stated "comparison" formula field. The problem is automation results in errors 80% of times: "Trying to add a non-unique value to a field marked unique". I guess this happens because at the point the scope for automation's actions is defined, the field "DestinationExists?" is still "False". I experimented further and tried adding a field "Destination added by automation" to "Loads" and added second action of the automation typing "Yes" into it, and respectively filtering the scope by it. I may have to observe it for a little more, but it seems that the trick did not work. Also tried creating summary fields both ways (Loads -> Destination IDs MD & Destination IDs MD -> Loads) but also with no luck, maybe i'm doing it wrong. I'm pretty sure this is a common problem and would like to know what is a generally accepted, "good" approach towards handling it.