Need some help with automation of quickbase with another system (Web service SOAP REQUEST).

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Need some help with automation of quickbase with another system (Web service).

 

I regularly import each 10 minutes data from my store system.

 

I am not technical but achieved to do that (with dans diebolt insights), using JavaScript in the quickbase home pages.

 

1. - I have a script that reloads the browser every 10 minutes

 

2. - I have a JavaScript that makes the call to my web service, transforms the data and imports into quickbase tables.

 

It works but I think I have to move forward and learn how to do this from the server side.

 

Is there anyone that can point me to the right direction, which language: Node, Ruby, Java, C++, Python should I investigate to achieve this on my own?

 

Any Internet literature where I could find some hints about this?

For a non tecnichal tra can learn some technical stuff

 

Thanks a lot

 



 
Photo of eduardo

eduardo

  • 40 Points

Posted 2 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,204 Points 20k badge 2x thumb
Your inquiry is so general I don't know where to start analyzing it. What is the problem you are trying to solve? My only thought is that you are polling you store very frequently and perhaps your store should be calling a QuickBase API when something happens.

Other than that Happy New Year!
Photo of eduardo

eduardo

  • 40 Points
Hi Dan, happy New Year.

I now it is general, because I wanted to learn a little bit before being more specific and ask some intelligent questions.

1. - I have a web service (SOAP REQUEST) to my store system than I can consume.


2. - I managed to create a SOAP REQUEST using JavaScript.

I use your Image unload (not the latest jet) top put the JavaScript on a web page.
The request returnns a XML

As I did not now how to automate; Pick up data from my store every 10 minutes to do this and then this...

I implemented also a dashboard widget (that I copied from you) that refreshes the Browser

  <script>
    window.setInterval(function() {
    window.top.location.reload(true);
  }, 500000);
    </script>
 </head>.

So my setting is, browser is refreshed, JavaScript snippet is called and the magic happens.
All those things I learned with you by the way

I need to run some other processes, during the night, every 4 hours etc., and I thought the right way to go is to do that automation from the server side.

I don’t want to learn any language I just want to learn some things so I can reproduce the same setting as above:
Run soap request, transform the data and import into quickbase, but with some flexibility.

Every 10 minutes, justt night etc.

I wanted to READ something about it, and as this can be done in many forms and languages, pick the most easy or rational for a non technical as me but that can copy and paste as hell.

I am using workato to send sms and survey monkey etc but I haven’t seen something to automate in thisway with transformations etc.