Date isn't converted ... View more

Thanks, Everything looks good but the isn't converted to that format 2021-11-18T09:07:54.382Z Log : "https://rest.xyz.com/abc/def/?filters=expecteddel<1952863053.113Z;status==1001" This is how it printed the url. ... View more

It's my bad the api url is https://xyz com/abc/def/?filters=expecteddel<YYYY-MM-DDTHH:MM:SS.000Z;status==1001 The must be converted into a macro variable as shown above ex ... View more

Hi All, I've got some api url named https://xyz.com/abc/def/expecteddel<YYYY-MM-DDTHH:MM:SS.000Z;status==1001 So over there YYYY-MM-DDTHH:MM:SS.000Z should be daily wise datetime and that datetime and status==1001 must be used as macro variable to create a url. For ex, %let host= rest.xyz.com; %let uri=/abc/def; %let date must be equal to YYYY-MM-DDTHH:MM:SS.000Z; to this format. %let status must be equal to ==1001. So the final url looks like this. %let url=&host.&uri.&date.&status.; So, can anyone help me out on how to achieve the above url macro variable please. Any help appreciated. Thanks. ... View more

I didn't have any date time value stored. I need to take the daily wise system date to convert it to YYYY-MM-DDTHH:MM:SS.000Z. Thanks. ... View more

Does it relates to postman. I thought that might be a complex one to be frank. ... View more

I apologise, I'm supposed to create a api query which fetches data from an api and stores required data into a new table by using postman software. ... View more

Rest API ... View more

I need to create a query which fetches data from an api and stores required data into a new table. ... View more

Thanks for letting me know it was my bad unfortunately I kept semicolon over there but there was no semicolon on my code. My issue is I have 5 columns in a dataset of those 2 needs to be converted to numeric. I used input func and also you can refer my code. Eventually the resultant dataset has only format changed columns rather having all the columns in the output dataset. I need some assistance in having include the rest of the columns as well. ... View more

What I exactly need is among the 5 columns which has huge records. Two of them must be converted char to numeric and the resultant dataset should have format changed columns as well as rest of the columns(un formatted columns). ... View more

Yes, but that want output dataset hasn't had the rest of the columns. ... View more

FYI, The columns has char data which are numeric but the type of the column variable is char. ... View more