Sending Data from Make.com to Bubble.io

Need help APIs
1

I’m trying to send data from a http request in make.com to bubble.io.

My challenge is that I want to add data to a database but it has a relationship with another database.

in this instance its the User, our primary field is the users email, but I have tried sending this as user id and user email? But neither are accepted.

I receive errors in make.com such as :

Error: 400 Bad Request
{“status”:“error”,“message”:“Invalid data for field User: object with this id does not exist: rob@thepursuitagency.com”,“body”:{“statusCode”:400,“body”:{“status”:“MISSING_DATA”,“message”:“Invalid data for field User: object with this id does not exist: rob@thepursuitagency.com”}}}
{“status”:“error”,“message”:“Invalid data for field User: object with this id does not exist: rob@thepursuitagency.com”,“body”:{“statusCode”:400,“body”:{“status”:“MISSING_DATA”,“message”:“Invalid data for field User: object with this id does not exist: rob@thepursuitagency.com”}}}
{“status”:“error”,“message”:“Invalid data for field User: object with this id does not exist: rob@thepursuitagency.com”,“body”:{“statusCode”:400,“body”:

Error: 400 Bad Request
{“status”:“error”,“message”:“Invalid data for field User: object with this id does not exist: [object Object]”,“body”:{“statusCode”:400,“body”:{“status”:“MISSING_DATA”,“message”:“Invalid data for field User: object with this id does not exist: [object Object]”}}}
{“status”:“error”,“message”:“Invalid data for field User: object with this id does not exist: [object Object]”,“body”:{“statusCode”:400,“body”:{“status”:“MISSING_DATA”,“message”:“Invalid data for field User: object with this id does not exist: [object Object]”}}}
{“status”:“error”,“message”:“Invalid data for field User: object with this id does not exist: [object Object]”,“body”:{“statusCode”:400,“body”:{“status”:“MISSING_DATA”,“message”:"In

I am trying to send this via bulk api… https://example.com/api/1.1/obj/GSC_Query_Data/bulk

My text aggregator prior to this is this:

{“page”:“{{get(421.keys; 1)}}”,“query”:“{{get(422.data.rows.keys; 1)}}”,“clicks” :{{ifempty(parseNumber(422.data.rows.clicks); 0)}},“impressions”:{{ifempty(parseNumber(422.data.rows.impressions); 0)}},“ctr”:{{ifempty(parseNumber(422.data.rows.ctr); 0)}},“position”:{{ifempty(parseNumber(replace(422.data.rows.position; “,”; “.”)); 0)}},“GSC site url”:“{{194.gsc_site_url}}”,“User”:[“{{194.user_email}}”],“Page Data URL”:[{“id”:“{{get(421.keys; 1)}}”}]}

I would Appreciate any help!

2

id needs to be the users ID not email

you can send data to bubble two ways

  1. mapped to specific input fields in the api workflow
  2. as a raw json that is then parsed by bubble (use the “detect request data”)