Yes sorry about that, my api_results variable has 
{"id":1084,"slug":"twitter-sportchek","name":"Twitter - SportChek","pr
+ovider":{"id":44,"slug":"twitter","name":"Twitter - Shared","access_t
+ype_cd":null,"login_method":"spider","launch_timeout":45,"capabilitie
+s":{"has_import":false,"has_password_reset":true,"has_provision":fals
+e,"has_saml":false,"has_sync":false,"unsupported_browsers":[],"servic
+es":"authenticatable","auth_or_directory":false,"has_ou":false},"icon
+s":{"small":"https://am.com/a/images/apps/twitter_sm.png","large":"ht
+tps://assets.bitium.com/a/images/apps/twitter_lg.png","color_code":"7
+c8d95","first_letter":"t"}},"configuration":{"saml":false,"login":rtc
+hek","url":"https://twier.com","extra":null,"install_type":"shared","
+authentication_type":"browser","launch_method":"get","namespace":["tw
+itter.com"]},"labels":[],"created_at":"2017-06-09T23:22:15.571-07:00"
+,"status":"active","key_vault":false,"requires_mfa_code":false},{"id"
+:109291,"slug":"rei-spredfast","name":"REI - Spredfast","provider":{"
+id":5561,"slug":"spredfast","name":"Spredfast","access_type_cd":null,
+"login_method":"spider","launch_timeout":45,"capabilities":{"has_impo
+rt":false,"has_password_reset":false,"has_provision":false,"has_saml"
+:false,"has_sync":false,"unsupported_browsers":[],"services":"authent
+icatable","auth_or_directory":false,"has_ou":false},"icons":{"small":
+"https://assom/a/images/apps/spredfast_sm.png","large":"https://asset
+s.bitium.com/a/images/apps/spredfast_lg.png","color_code":"65c6bb","f
+irst_letter":"s"}},"configuration":{"saml":false,"login":"reiteamocia
+l","url":"https://www.spredfast.com","extra":null,"install_type":"sha
+red","authentication_type":"browser","launch_method":"get","namespace
+":["www.spredfast.com"]},"labels":[],"created_at":"2017-06-19T12:33:3
+3.561-07:00","status":"active","key_vault":false,"requires_mfa_code":
+false}]

[download]

But after running the code I am getting the error Not a HASH reference at line 79, <> line 2. line 79 is push @insert,$row->{$var};

In reply to Re^6: Perl Database Entries by cbtshare
in thread Perl Database Entries by cbtshare

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.