Forum Discussion

tross4012's avatar
tross4012
Helper I
4 years ago
Solved

Syntax Issues with API Call

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

  • Anonymous's avatar
    Anonymous
    4 years ago

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

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