Forum Discussion

BobThomas1's avatar
BobThomas1
Qrew Cadet
4 years ago

Code Pages

I am trying to incorporate a method to grab four specific fields from an AthenaHealth database. (Right now I'm using a 'sandbox' data table, with Dr names, Encounter dates, Type of visit & location.  ...
APIs and custom code
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
I don't think that you need to use a programming languages at all. Just native Pipelines as it can digest a JSON response to a webservice call.

https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=89ce5407-8f15-42e8-963e-2b8a4fe64fd8&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bm89ce5407-8f15-42e8-963e-2b8a4fe64fd8

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
BobThomas1's avatar
BobThomas1
Qrew Cadet
4 years ago
Mark,

AthenaHealth has several scripts (on GitHub now). The script I modified in JavaScript (with Node.js) will bring an Encounter record with the four fields I need in JSON format. I'm not sure how to get without the code? 

I suppose the actual API Urls might work, but I have to also have my OAuth & token values securely in the (code page) I think. The QuickBase URLs will need to be added to the script to create the new record, and of course the Pipeline scheduled to run at regular intervals, probably daily, maybe weekly.

------------------------------
Bob T.
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    I'm  not a programmer, but if you can do a webservice call, then I'm quite sure that the Pipeline can listen for the response and parse the JSON.  But I am not familiar enough with that process to be able to specifically give you the step-by-step on that.  You could try going to Quickbase support for help on that or it's also possible that the QuickBase junkie can help you on a consulting basis.  https://www.quickbasejunkie.com/


    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • BobThomas1's avatar
      BobThomas1
      Qrew Cadet
      4 years ago
      I believe no-code or low-code is good for non-programmers. So much versatility to work with both, as my dad, a guy learned to program in his civilian armed forces engineer job. He taught me assembly language. BUT he would use both high-level language for ease, but where speed was needed then he used assembly. I never did as good as he was with that language. 

      I think you are right this could probably be done with less code if it was just QB, but AthenaHealth APIs are not as friendly. In fact they are sometimes a bit Beta. 

      My problem is I have a module that works in Node.js. But I'm trying to get to work in just JavaScript. But as you have said, JavaScript integrates in a Web Browser nicely.  I know Python, but don't know how to put into a Web Browser. 

      I am re-watching this video on Python  & Quick Base by John Karas. He refers to a more recent video, sometime after June of 2020 on (see image) on ODBC. I just found on the recorded events from QB university. (see 2nd image).

      I think that is the way I want to go, since I can program. I do see that the future will be more no-code/low-code but it will be 50 years before code will be completely replaced if even then. I will be watching from the Cloud, lol! (analogy - I told mom when I was in high school I wanted to be a dentist, but the futurists were saying that we wouldn't need dentistry in 20 or more years. Mom told me over lunch at a Big Boy restaurant, there will still be a need for dentists somewhere in the world.)

      ------------------------------
      Bob T.
      ------------------------------