Syntax Issues with API Call

tross4012 — Wed, 20 Apr 2022 16:44:33 GMT

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]),

Re: Syntax Issues with API Call

Anonymous — Thu, 21 Apr 2022 18:13:46 GMT

tross4012 - I think you resolved this. But there is an & missing after Number.ToText( limit )

topic Re: Syntax Issues with API Call in DAX Commands and Tips

Syntax Issues with API Call

Re: Syntax Issues with API Call