Skip to main content
Solved

Pipelines automation to change record owner

  • July 29, 2022
  • 0 replies
  • 751 views

Good morning,
In short, I have created a pipeline that triggers on an event inside 'record 1'. It then creates 'record 2'. 'Record 2' ends up being created/ owned by me, however, I would like to change that to the person who created/ owns 'Record 1'. 
I am open to all ideas and suggestions.
Thank you for your time.

Kind regards,
Shane Miller

------------------------------
Shane Miller
------------------------------

Best answer by JosephMahon

Had some trouble getting the original fix to work but I met with Mark and we were able to make this work using just the URL and not the body.  Here is the URL we used. 

 

https://mycompany.quickbase.com/db/DBID?a=API_ChangeRecordOwner&rid={{a.id}}&newowner={{a.update_eoc_record_owner_to.email}}

This topic has been closed for replies.

RaziD
Forum|alt.badge.img+3
  • Registered
  • August 4, 2022
Hi Shane;
You can add another step for API_ChangeRecordOwner.
You can add a Webhook or a Json Handler in pipeline to change owner of newly created record to user you want.

Please see: https://help.quickbase.com/api-guide/change_record_owner.html

I hope this helps.

------------------------------
Razi D.
Desta Tech LLC
razi@destatechs.com
------------------------------

Forum|alt.badge.img+5
  • Registered
  • July 2, 2024

I know this is an older post but I wanted to share an issue I am having. 

No matter what I do, I am getting error: Remote service reported an error: HTTP status code 404 for URL

The DBID is accurate as is the app and user token's.

Interestingly whenever I put in the URL for the table it defaults to homepage.  I noticed it does that for all of my tables.  Wondering if there is a setting I am missing?


Forum|alt.badge.img+5
  • Registered
  • July 2, 2024

Yeah, but I can tell for sure that it is the correct URL.

Yeah, what I mean is that in my web browser when I put in my table URL, it defaults to the APP home page.  I am getting the table URL directly from the URL Bar when I navigate to the table, but if pasted into another tab it redirects to APP home page.  


Forum|alt.badge.img+5
  • Registered
  • July 2, 2024

Ah okay. That makes sense and I can see that it checks out!

Still runs the 404 error for me.  Wondering if I have a permissions error.  I am wondering if I don't have full administration rights (even though I should).  Would that cause the error for this kind of call?


Forum|alt.badge.img+5
  • Registered
  • Answer
  • July 8, 2024

Had some trouble getting the original fix to work but I met with Mark and we were able to make this work using just the URL and not the body.  Here is the URL we used. 

 

https://mycompany.quickbase.com/db/DBID?a=API_ChangeRecordOwner&rid={{a.id}}&newowner={{a.update_eoc_record_owner_to.email}}