The bolded part is the nasty bits. I have tried several different versions of that but am not having much luck. Not sure why, I am new to PowerQuery. Not even sure if this is how it's done. It certainly is easier to do something like this in Google Sheets with the json functions there. It would be nice if WEBSERVICE in excel would just work given an https. It seems dirty to have to run 1 query to get a list of all the IDs I need then have to run 1000+ queries to get the detail but that's how the API is designed for the external system I am working with. I don't understand why I can't just directly reference a column in the spreadsheet I am working with that has this URL already concatenated. I am probably not doing this the right way, just trying to hack it out. I can hit the connection just fine and pull all the IDs I need, its just drilling down to the next level is proving difficult.
I also get this error, when I try and use an _
Expression.Error: The name '_' wasn't recognized. Make sure it's spelled correctly.
Your syntax look correct. Just to confirm you are using this in a custom column in a table that has a column called Column1.ApplicationID.
If so, to troubleshoot you can try to hard code in one of your ID values like below to narrow it down to the Text.From part. You could separately make a custom column with Text.From(... to confirm you are pulling the ID value as text correctly.