I'm still searching for the best way to handle this as my method above is not ideal and adds complexity. I've found a few posts that describe nested arrays and adding a second iterate step to the pipeline to handle. Give these a review. Hope these help. *I still cannot get these link to other discussions to work; receiving content publish error.
https://community.quickbase.com/discussions/quickbase-discussions/instructions-for-oauth2-using-pipelines/86142
https://community.quickbase.com/discussions/quickbase-discussions/pipeline-iterate-over-json-nested-data/73745
