Syntax issues in API call

[tross4012]

Can anyone identify what is wrong with this function?

I know a "Token Comma Expected" however, I cannot figure out to fix this problem. The bolded/underlined phrases below are whats giving me this problem:

Source = Csv.Document(Web.Contents("https://ClinicalTrials.gov/api/query/study_fields?&fields=NCTId,LeadSponsorName,Phase,BriefTitle,Org...max_rnk=" & Number.ToText( limit )"&fmt=csv&min_rnk=" & Number.ToText( offset )),[Delimiter=",", Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),

[amitchandak · Accepted solution]

@tross4012 , Position of double quote and & has issue while you can combining the text

Source = Csv.Document(Web.Contents("https://ClinicalTrials.gov/api/query/study_fields?&fields=NCTId,LeadSponsorName,Phase,BriefTitle,Org..." & Number.ToText( limit )&"&fmt=csv&min_rnk=" & Number.ToText( offset )) &",[Delimiter=",, Columns=7, Encoding=65001, QuoteStyle=QuoteStyle.None]),

might need more correction

[tross4012]

Thank you so much!