How can I pass a number with leading zero's as a parameter in PQ?

[JumboCactuar]

Hi, I've looked all over for a solution to this but nothing. I'm trying to pass a number as a parameter into a URL, keeping the leading zero's.

Example: 000129832 When I enter this it gets passed as 129832 which doesn't work in the URL

I have this:

    let SR=(ACNUM)=>
    let
        Source = Xml.Tables(Web.Contents("http://exampleurl.com?ACNUM="&Number.ToText(ACNUM))),

And when I enter 000129832 the invoked function shows error "Column of the table not found" as it is trying to load

http://exampleurl.com?ACNUM=129832

Appreciate any help with this

Also posted on Reddit: https://www.reddit.com/r/excel/comments/bzou90/cant_pass_number_into_url_keeping_leading_zeros/

 

[Norie]

Does the 'number' you want to pass always have the same no of digits?

If it does you might want to look at Text.PadStart:

Source = Xml.Tables(Web.Contents("http://exampleurl.com?ACNUM="&Text.PadStart(Number.ToText(ACNUM), 9, "0"))),

 

[JumboCactuar]

@Norie

Thankyou this is working