Skip to main content
Question

api_addQuery from a Database table

  • August 1, 2019
  • 0 replies
  • 19 views

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;;

This topic has been closed for replies.

Forum|alt.badge.img+12
  • Quickbase Alumni
  • August 2, 2019
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/