Forum Discussion

KiranTauqir's avatar
KiranTauqir
Qrew Trainee
5 years ago

api_addQuery from a Database table

hi, i am trying to add rows in my Table on Quick Base through API / xml from my Database table. i am trying to use the API_addRecord but unable to add them - any help will be useful.



SELECT
        to_chars (
            w.result
            ,'UTF-8'
        )
    FROM
        (
            EXEC"ws".invokeHTTP (
                "action" => 'GET'
                ,"endpoint" => 'https://cyber-7434.quickbase.com/db/bps3fqk9w?a=API_AddRecord&username=kiran.tauqir@cyber-soluti...;'
            )
        ) AS w;;

10 Replies

  • fid_6= and fid_7=.  You appear to be missing the _ in the link that I can see.  Don't know if this will solve your overall problem.
  • May I suggest Qunect as it appears you're using SQL in your above sample? I think you'll find an ODBC connection in which you can use SQL/OPENQUERY directly much more preferable :)

    https://www.qunect.com/
    • KiranTauqir's avatar
      KiranTauqir
      Qrew Trainee
      thanks . i will try it, but we are keeping all our connectors on Data virtuality, thus wanted to keep this QUickBase in data virtuality as well