How do I copy a record via api?

You will use the API_Add Record.  each source field needs to be mapped into the corresponding target field.



It will look something like

urlroot() & "db/" & [_DBID_TARGET_TABLE] & "?act=API_AddRecord"

& "&_fid_6=" & urlencode([source field])

& "&_fid_7=" & urlencode([a different source field])

& "&_fid_8=" & urlencode([yet a different source field])

Hi, I'm trying to create an API button to copy a record along with a child and multiple grandchild records (I have looping relationships so I can't use the Copy Master Detail wizard), what is the format for this? Thank you!!! 

The API and the Wizard button use the same underlying API. So they have the same limitations.

I have a client who absolutely needed to copy with children / grand children, and we ended up contracting with another QSP to write s script.

Contact me off line for more information.

QuickBaseCoach.com

Ahhh, shoot. Well, what about this - What if I copy the middle record (the parent, but not the grandparent)? When I do that just by clicking more - copy this record, I have the option to create a new grandparent record in my related job (grandparent record) dropdown on the parent record form. Is there a way to get it to automatically copy the parent record with its children and then send the user directly to the add/edit view of the new grandparent record form? 

Sorry if that's convoluted. 

If you can get the copy button working on the Parent, then I can help land you on the Add Grand Parent Record.

Awesome! So I would just start with the API button you described above on the Parent?



urlroot() & "db/" & [_DBID_TARGET_TABLE] & "?act=API_AddRecord"

& "&_fid_6=" & urlencode([source field])

& "&_fid_7=" & urlencode([a different source field])

& "&_fid_8=" & urlencode([yet a different source field])

Or would I do the Copy Master Detail API? 


I saw this in a different post:

var text CopyMasterDetail = URLRoot() & "db/" & Dbid() & "?a=API_CopyMasterDetail&destrid=0&sourcerid=" & ToText([Record ID#])
& "&apptoken=" // if you have app tokens enable, put it in here
& "&copyfid=6" // replace the 6 insert the fid for the invoice# field here
& "&relfids=7"; // replace the 7 with the fid for the report link field on the relationships between invoice and lines
// typically it would be called Invoice Lines or Perhaps Lines.
// remember to end your formula variable with a semicolon.

Yes, you need to use the api in order to control where to land the user.

Which direction do you recommend I go with it? API_CopyMasterDetail or API_AddRecord ?

I don�t understand. Only the copy master detail api will copy children and grand children.