Appsheet API Help

[bmayers]

I have a table that we create a PM record on with a PM_Number (equals frequency) 7, 14, 28 day.

From there the save event writes a record of it to the PM_Services there with a formula to calculate the Deadline_Date.

 From there PM_Services rows will either be

Completed (Completed Date added by User)

or 

Expired (If todays date > Deadline_Date) 

I was using an automation to run at 2am every wednesday if completed date is not blank it would change status to Completed and make a copy of that row and add a new row on the PM_service table with a new deadline date for next week. if the completed date was blank it would change the status to Expired and make a copy of that row and add a new row on the PM_service table with deadline date for next week. The issue is with this is the Key column. i am using the following formula 

concatenate(
"PM_Job-",
count(PM_Service[PM_ServicesID])+1
)

So When the automation runs it might create 10+ Rows and by doing so it gives them all the same key....

Solution i found was using appsheet API however i cant seem to make it work. Here is what i have so far.