Multi step API not triggering a new record creation

Question

Hello everyone, relatively new and really getting into the idea of API buttons to automate a lot of things.&nbsp; The first more complex one I am creating is the deal won button for an opportunity.&nbsp; When this happens I want to trigger a few things based on the opportunity type (for me design or build).&nbsp; The first part of this API works fine, deal won stage is changed and the date won is set to Today().&nbsp; But it is not creating the new task to create the sales order and I cannot figure out why or how to debug this to figure it out.&nbsp; Any help would be appreciated!//Button Functionality://1.&nbsp; Change the stage of the opportunity to won//2.&nbsp; Set the Date Won to Today//3.&nbsp; Check to see if opportunity is of type design.&nbsp;&nbsp;//&nbsp; &nbsp; &nbsp; If true, assign a task to Lisa to create the sales order.//4.&nbsp; Redirect back to the same form to display the record with updates.//*******************************************************************************************************************//Step 1 and 2var text urlOne = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;rid=" &amp; [Record ID#] &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_9=Won" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_23=" &amp; URLEncode(Today());//Step 3 - Build urlTwo variable if the type is design.&nbsp; This assigns the sales order creation to lisa as a task.var text urlTwoIfDesign = URLRoot() &amp; "db/" &amp; [_DBID_TASKS] &amp; "?a=API_GenAddRecordForm" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_31=" &amp; URLEncode(ToUser("ljording@elitestudioe.com")) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_36=" &amp;URLEncode("Task created automatically through Opportunity Win Button") &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_9=" &amp; URLEncode(ToWeekdayN(Today())) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_12=" &amp; [Record ID#] &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_21=" &amp; [Project] &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_24=Active" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_38=" &amp; URLEncode(ToText(ToUserList([Project Solutions T1],[Project Solutions T2]))) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_23=Opportunity" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; URLEncode("&amp;_fid_83=Not Applicable") &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_6=Create Sales Order - Design Opportunity";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;//Step 3 - Build urlTwo variable if the type is build.&nbsp; THE FOLLOWING IS A COPY OF THE ABOVE AS I DID NOT BUILD THE LOGIC OUT YETvar text urlTwoIfBuild = URLRoot() &amp; "db/" &amp; [_DBID_TASKS] &amp; "?a=API_AddRecord" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_31=" &amp; URLEncode(ToUser("ljording@elitestudioe.com")) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_36=" &amp;URLEncode("Task created automatically through Opportunity Win Button") &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_9=" &amp; URLEncode(ToWeekdayN(Today())) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_12=" &amp; [Record ID#] &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_21=" &amp; [Project] &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_24=Active" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_38=" &amp; URLEncode(ToText(ToUserList([Project Solutions T1],[Project Solutions T2]))) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_23=Opportunity" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; URLEncode("&amp;_fid_83=Not Applicable") &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_6=Create Sales Order - Design Opportunity";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;//Step 4var text redirect = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=dr&amp;rid=" &amp; [Record ID#];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;//URL ExecutionCase(true,[Opportunity Type] = "Design", $urlOne &amp; URLEncode($urlTwoIfDesign) &amp; "&amp;rdr=" &amp; URLEncode($redirect),[Opportunity Type] = "Build", $urlOne &amp; URLEncode($urlTwoIfBuild) &amp; "&amp;rdr=" &amp; URLEncode($redirect))

quickbasecoachd · Answer

?a=API_GenAddRecordForm"&nbsp; will pop up an Add Record form for a human user to complete and manually save.&nbsp; That could only be used as the very last step in an API Button.?a=API_AddRecord"&nbsp; will create a record.You want to use the latter API

ivanweiss · Answer

I actually do have that, I changed it to gen addrecordform in an attempt to troubleshoot to see if it ever showed the form.&nbsp; It does not show the form and it does not add the record

quickbasecoachd · Answer

I'm confused now.&nbsp; Can you post the code that is not working?

ivanweiss · Answer

It is that same code, I just fixed that one line you mentioned.&nbsp; But it is not running that add API//Button Functionality://1.&nbsp; Change the stage of the opportunity to won//2.&nbsp; Set the Date Won to Today//3.&nbsp; Check to see if opportunity is of type design.&nbsp;&nbsp;//&nbsp; &nbsp; &nbsp; If true, assign a task to Lisa to create the sales order.//4.&nbsp; Redirect back to the same form to display the record with updates.//*******************************************************************************************************************//Step 1 and 2var text urlOne = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=API_EditRecord" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;rid=" &amp; [Record ID#] &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_9=Won" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_23=" &amp; URLEncode(Today());//Step 3 - Build urlTwo variable if the type is design.&nbsp; This assigns the sales order creation to lisa as a task.var text urlTwoIfDesign = URLRoot() &amp; "db/" &amp; [_DBID_TASKS] &amp; "?a=API_AddRecord" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_31=" &amp; URLEncode(ToUser("ljording@elitestudioe.com")) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_36=" &amp;URLEncode("Task created automatically through Opportunity Win Button") &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_9=" &amp; URLEncode(ToWeekdayN(Today())) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_12=" &amp; [Record ID#] &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_21=" &amp; [Project] &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_24=Active" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_38=" &amp; URLEncode(ToText(ToUserList([Project Solutions T1],[Project Solutions T2]))) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_23=Opportunity" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; URLEncode("&amp;_fid_83=Not Applicable") &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_6=Create Sales Order - Design Opportunity";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;//Step 3 - Build urlTwo variable if the type is build.&nbsp; THE FOLLOWING IS A COPY OF THE ABOVE AS I DID NOT BUILD THE LOGIC OUT YETvar text urlTwoIfBuild = URLRoot() &amp; "db/" &amp; [_DBID_TASKS] &amp; "?a=API_AddRecord" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;apptoken=c5gchf9bhwx6umbd2ii5zdqtb5x8" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_31=" &amp; URLEncode(ToUser("ljording@elitestudioe.com")) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_36=" &amp;URLEncode("Task created automatically through Opportunity Win Button") &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_9=" &amp; URLEncode(ToWeekdayN(Today())) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_12=" &amp; [Record ID#] &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_21=" &amp; [Project] &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_24=Active" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_38=" &amp; URLEncode(ToText(ToUserList([Project Solutions T1],[Project Solutions T2]))) &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_23=Opportunity" &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; URLEncode("&amp;_fid_83=Not Applicable") &amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "&amp;_fid_6=Create Sales Order - Design Opportunity";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;//Step 4var text redirect = URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=dr&amp;rid=" &amp; [Record ID#];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;//URL ExecutionCase(true,[Opportunity Type] = "Design", $urlOne &amp; URLEncode($urlTwoIfDesign) &amp; "&amp;rdr=" &amp; URLEncode($redirect),[Opportunity Type] = "Build", $urlOne &amp; URLEncode($urlTwoIfBuild) &amp; "&amp;rdr=" &amp; URLEncode($redirect))

laurathacker · Answer

You may need to double-encode the redirect.URLEncode(URLEncode($redirect))

Forum Discussion

Multi step API not triggering a new record creation

Related Content

Pipeline Not Triggering

Document creation - Save PDF to field in record

Custom Record Titles

Document Template creation - Save PDF to field in record

Using Grid Edit to Edit Multiple Records at Once