accessing data directly in database

Permalink Browser Info Environment
hi, we need to submit data do a third party api after its been saved to the database. in other words, we have a form (its actually an Advanced Forms form) and after its been successfully submitted, we want to automate the process of sending the data that was just submitted, to the API of our client.

we are using the 'Pass record ID to this page?' setting to access an ID number on a Single Page we redirect to after submission. now we'd like to pull the submitted fields from the database using the ID, and then format the data and send it to the client's API.

is this possible? and could you please help us understand where and how submissions are stored in the C5 database ?

thank you

Type: Pre-Sale
Status: In Progress
sumeetwork
View Replies:
sumeetwork replied on at Permalink Reply
sumeetwork
we found the tables, all appended with 'sixeightforms' - please ignore this request.

concrete5 Environment Information

# concrete5 Version
5.6.1.2

# concrete5 Packages
Advanced Forms (1.13.1), Awesome Table (1.0.4), Custom Contact Form (3.0), Custom Subscribe Form (3.0), Dynamic Iframe (1.61), Expand / Collapse (1.2.0), Facebook OpenGraph Tags (0.9.1), Image Blank Target (1.0), Load jQuery UI (1.4.3), Metaphor Blocks (1.0.0), Metaphor Grid (1.0.0), Neuron Responsive C5 Theme (1.0.1), Redirect (1.1), Social Sharing (1.3), Url Director (1.6.5).

# concrete5 Overrides
blocks/autonav, blocks/image, elements/page_controls_header.php, elements/header_required.php, js/main.js, js/fademenu.js, js/mobile-datepicker-wrapper.jquery.json, js/package.json, js/off-canvas-menu.js, js/jquery.mobile-1.4.5.min.js, js/datepicker.js, js/jquery.mobile.datepicker.js, js/validator.js, js/jquery.mobile-1.4.5.min.map, js/jquery.min.js, js/join-form.php, css/images, css/PIE_uncompressed.htc, css/offcanvas-styles0202.css, css/jquery.mobile.structure-1.4.5.min.css, css/custom23022015.css, css/jquery.remodal.css, css/jquery.mobile.icons-1.4.5.min.css, css/jquery.smartbanner.js, css/custom20022015.css, css/custom_0202.css, css/PIE.php, css/jquery.mobile.theme-1.4.5.min.css, css/custom----.css, css/custom---.css, css/ie8.css, css/header.php, css/jquery.mobile-1.4.5.min.css, css/PIE_uncompressed.js, css/custom0202.css, css/--jquery.mobile.theme-1.4.5.min.css, css/custom.css, css/PIE.htc, css/custom20150903.css, css/custom04022016.css, css/jquery.mobile.external-png-1.4.5.min.css, css/d3socialsharing.css, css/jquery.mobile.datepicker.theme.css, css/custom27012015.css, css/jquery.mobile.datepicker.css, css/customBK20121126.css, css/offcanvas-styles0502.css, css/jquery.mobile.inline-svg-1.4.5.min.css, css/PIE.js, css/main.css, css/offcanvas-styles.css, css/custom_0302.css, css/--jquery.mobile.icons-1.4.5.min.css, css/jquery.mobile.inline-png-1.4.5.min.css, single_pages/call-me-submit-code.php, single_pages/images, single_pages/join-now-code.php, single_pages/call-me-back-codeBK.php, single_pages/iframe-call-me-back-code.php, single_pages/validateid.php, single_pages/callme-thankyoucodenew.php, single_pages/call-me-back-code0502.php, single_pages/submit-final.php, single_pages/jq-idealforms-old-master----, single_pages/head.jpg, single_pages/call-me-submit-code0502.php, single_pages/callme-thankyoucodeBK13102015.php, single_pages/url-record.txt, single_pages/join-now-product_bkp31012014.php, single_pages/call-me-submit-codeBK10032016.php, single_pages/submit.php, single_pages/callme-thankyoucode0502.php, single_pages/join-now_bkp31012014.php, single_pages/test.php, single_pages/join-now_BK20141008.php, single_pages/join-now-thankyou18052015.php, single_pages/backup-20140714, single_pages/join-nowBK.php, single_pages/join-now-bkp-Jo.php, single_pages/call-me-code0502.php, single_pages/call-me-back-code_BK20141008.php, single_pages/join-now-thankyou-BK13032014.php, single_pages/call-me-back-codeBK27112014.php, single_pages/contact-thankyou.php, single_pages/join-now-productBK.php, single_pages/call-me-submit-code---.php, single_pages/--join-now-product.php, single_pages/MFC43D2.tmp, single_pages/jsBK, single_pages/join-nowBK28052015.php, single_pages/--call-me-code.php, single_pages/callme-thankyoucode-.php, single_pages/call-me-submit-codeBK.php, single_pages/--join-now.php, single_pages/join-now-product_BK20141008.php, single_pages/iframe-join-now.php, single_pages/call-me-back-code_20141103.php, single_pages/submit-finalBK.php, single_pages/call-me-code18052015.php, single_pages/--call-me-submit-code.php, single_pages/\, single_pages/backup, single_pages/callme-thankyou.php, single_pages/js, single_pages/call-me-code.php, single_pages/join-now-product_V.php, single_pages/--submit.php, single_pages/submit-final---.php, single_pages/submit-finalBK13102015.php, single_pages/submitBK.php, single_pages/join-now-product-code.php, single_pages/form_process, single_pages/form_process.php, single_pages/callme-thankyoucode09022015.php, single_pages/join-now09042015.php, single_pages/submit-final-code.php, single_pages/cssBK, single_pages/redirect-joinnow.php, single_pages/call-me-submit-codeBK13102015.php, single_pages/callme-thankyoucode18052015.php, single_pages/--submit-final.php, single_pages/submit-finalBK11032016.php, single_pages/join-now.php, single_pages/call-me-submit-wap.php, single_pages/call-me-back-code-.php, single_pages/submit---.php, single_pages/imgBK, single_pages/join-now-product.php, single_pages/callme-thankyoucode--.php, single_pages/join-form2.php, single_pages/test - Copy.php, single_pages/call-me-back-code---BK.php, single_pages/curl_test.php, single_pages/call-me-backBK.php, single_pages/join-now-productBK27112014.php, single_pages/logcallme.txt, single_pages/join-now20022015.php, single_pages/join-now-product_bk30062015.php, single_pages/join-now18052015.php, single_pages/submit-code.php, single_pages/phpinfo.php, single_pages/call-me-back-code--.php, single_pages/register-now.php, single_pages/join-now-thankyouBK13102015.php, single_pages/call-me-submit-code09022015.php, single_pages/join-form.php, single_pages/idealformsBK, single_pages/join-now-productBK23012015.php, single_pages/css, single_pages/registration-form.php, single_pages/backup-final form, single_pages/callme-thankyoucode.php, single_pages/join-now-product---.php, single_pages/join-now-thankyou.php, single_pages/submitbk11032016.php, tools/fixdb.php

# Server Software
Apache/2.2.22 (Debian)

# Server API
apache2handler

# PHP Version
5.4.41-0+deb7u1

# PHP Extensions
apache2handler, bcmath, bz2, calendar, Core, ctype, curl, date, dba, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, json, libxml, mbstring, mcrypt, mhash, mysql, mysqli, openssl, pcre, PDO, pdo_mysql, Phar, posix, Reflection, session, shmop, SimpleXML, soap, sockets, SPL, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, zip, zlib.

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 8M
sql.safe_mode - Off
upload_max_filesize - 2M
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.