Forum Discussion
tross4012
4 years agoHelper I
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]),
- Anonymous4 years ago
tross4012 - I think you resolved this. But there is an & missing after Number.ToText( limit )
1 Reply
- AnonymousNot applicable
tross4012 - I think you resolved this. But there is an & missing after Number.ToText( limit )