Forum Discussion
how to update query when the source data changes
If so, post the code of your query, otherwise try to clarify your problem
- ahmad aliMay 21, 2021Brass Contributor
Thanks! Lorenzo
You may want check the file attached I've added extra explanation with screen shots, I've also added the code ( but I am not allowed to share the API)
Many thanks!
- LorenzoMay 22, 2021Silver Contributor
I carefully looked at your query. No suprise, everthing is hard-coded (field names) when it comes to record's expansion, hence your problem. In a nutshell you have to make everything dynamic and that's not something easy when you're not familiar with https://docs.microsoft.com/en-us/powerquery-m/ (PQ language)
Also, you deal with a JSON document where a record/list/table can have nested records/lists/tables, each of them can have nested records/lists/tables... Expanding all is a serious challenge - to give you a sense have a look to ImkeF's function https://www.thebiccountant.com/2018/06/17/automatically-expand-all-fields-from-a-json-document-in-power-bi-and-power-query/ (I don't think her function can help you though)
Realistically speaking I don't see how someone can help without a bit of understanding on how the application (FULCRUM) works (re. records and the like it creates) and without an API key. I'm afraid I can't help you further with this but hope the above explainations will help you in a way or another
- ahmad aliJun 13, 2021Brass Contributorthanks, L Z.
looks like the solution is to generate a new API token then replace it with the one in the Query advanced editor