JSON query based on another query

Hi,

New to PowerBI, and having what is probably a simple problem but can't seem to get it figured. I am trying to load JSON data and I've got one query working like a charm, transformed into a table and performing as expected. My problem is the second query is based on information from the first (an ID field) and the third is based on information from the second (another ID field). The way the data API works that I'm accessing, I can't get all the data together so it will have to be three separate queries / tables.

My question is how do I build the second query to reference data from the first? I tried using the table name column structure (Table[Column]) as part of my URL string, but I get an error that says "Expression.Error: We cannot apply operator & to types Text and List.". I am positive I'm missing something little but I can't figure it out for the life of me. Here's the query for the first table, followed by the one I'm trying to use for the second:

First Table / Query = Surveys

let
    Source = Json.Document(Web.Contents("https://api.provider.com/" & "surveys?site_id=15626", [Headers=[Authorization="Bearer ACCESS_TOKEN", Accept="application/json", #"NGIN-API-VERSION"="0.1"]])),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"id", "name", "site_id", "created_at", "updated_at", "status", "tst_rate_group_num", "code", "survey_type", "registrar_emails", "allow_multiple_registrations", "next_event", "rep_user_id", "monetary", "open_date", "close_date", "bank_account_id", "merchant_account_id", "custom_message", "login_optional", "user_id", "has_barcode", "barcode_type", "group_range", "group_range_question_element_id", "editable_by_user", "form_label", "sub_form_label", "custom_css", "user_can_add_entries", "skip_welcome_page", "event_id", "customer_pays_fee", "offer_id", "allow_amex", "next_form_text_override", "restrict_invite", "background_screen_enabled", "approval_user_id"}, {"Column1.id", "Column1.name", "Column1.site_id", "Column1.created_at", "Column1.updated_at", "Column1.status", "Column1.tst_rate_group_num", "Column1.code", "Column1.survey_type", "Column1.registrar_emails", "Column1.allow_multiple_registrations", "Column1.next_event", "Column1.rep_user_id", "Column1.monetary", "Column1.open_date", "Column1.close_date", "Column1.bank_account_id", "Column1.merchant_account_id", "Column1.custom_message", "Column1.login_optional", "Column1.user_id", "Column1.has_barcode", "Column1.barcode_type", "Column1.group_range", "Column1.group_range_question_element_id", "Column1.editable_by_user", "Column1.form_label", "Column1.sub_form_label", "Column1.custom_css", "Column1.user_can_add_entries", "Column1.skip_welcome_page", "Column1.event_id", "Column1.customer_pays_fee", "Column1.offer_id", "Column1.allow_amex", "Column1.next_form_text_override", "Column1.restrict_invite", "Column1.background_screen_enabled", "Column1.approval_user_id"}),
    #"Renamed Columns" = Table.RenameColumns(#"Expanded Column1",{{"Column1.id", "ID"}, {"Column1.name", "Name"}, {"Column1.site_id", "SiteID"}, {"Column1.created_at", "CreatedDate"}, {"Column1.updated_at", "UpdatedDate"}, {"Column1.status", "Status"}, {"Column1.tst_rate_group_num", "RateGroupNum"}, {"Column1.code", "Code"}, {"Column1.survey_type", "SurveyType"}, {"Column1.registrar_emails", "RegistrarEmails"}, {"Column1.allow_multiple_registrations", "AllowMultiples"}, {"Column1.next_event", "NextEvent"}, {"Column1.rep_user_id", "UserID"}, {"Column1.monetary", "Monetary"}, {"Column1.open_date", "OpenDate"}, {"Column1.close_date", "CloseDate"}, {"Column1.bank_account_id", "BankAcctID"}, {"Column1.merchant_account_id", "MerchantAcctID"}, {"Column1.custom_message", "CustomMessage"}, {"Column1.login_optional", "LoginOptional"}, {"Column1.user_id", "User_ID"}, {"Column1.has_barcode", "HasBarcode"}, {"Column1.barcode_type", "BarcodeType"}, {"Column1.group_range", "GroupRange"}, {"Column1.editable_by_user", "UserCanEdit"}, {"Column1.form_label", "FormLabel"}, {"Column1.sub_form_label", "SubFormLabel"}, {"Column1.custom_css", "CustomCSS"}, {"Column1.user_can_add_entries", "UserCanAddEntries"}, {"Column1.skip_welcome_page", "SkipWelcomePage"}, {"Column1.event_id", "EventID"}, {"Column1.customer_pays_fee", "CustomerPaysFee"}, {"Column1.offer_id", "OfferID"}, {"Column1.allow_amex", "AllowAmex"}, {"Column1.next_form_text_override", "NextFormTextOverride"}, {"Column1.restrict_invite", "RestrictInvite"}, {"Column1.background_screen_enabled", "BackgroundScreenEnabled"}, {"Column1.approval_user_id", "ApprovalUserID"}})
in
    #"Renamed Columns"

Second Table/Query = SurveyResults

let
    Source = Json.Document(Web.Contents("https://api.provider.com/survey_results?survey_id=" & Surveys[ID],
        [Headers=[Authorization="Bearer ACCESS_TOKEN", Allow="application/json", #"NGIN-API-VERSION"="0.1"]]))
in
    Source

I'd greatly appreciate any information or help. I know the error message is referring to some sort of type mismatch between the URL and what I'm trying to append to it, but I figured I was just making that reference incorrectly. If I can get this sorted for the second table, I'm sure I can apply the same logic to the third table / query. Thanks in advance!